How many levels are in the If formula?

Question

excel

Entering the "If" formula produces the following error:

The specified formula cannot be entered because it uses more levels of nesting than is allowed by the current file format.

Link to file . When replacing the digit in the red cell from 1-10, the data from the yellow cell should be displayed, but when the threshold of 10% is reached, it produces 0.

Or what other formula can do this?

Answer 1

As far as I remember, there were 7 nestings (but this is not accurate). But no one forces you to do just that, you can do it differently.

=ЕСЛИ(И($F$1>0;$F$1<=G14);H14;0)+
ЕСЛИ(И($F$1>G15;$F$1<=G15);H15;0)+
ЕСЛИ(И($F$1>G16;$F$1<=G16);H16;0)+
ЕСЛИ(И($F$1>G17;$F$1<=G17);H17;0)+
ЕСЛИ(И($F$1>G18;$F$1<=G18);H18;0)+
ЕСЛИ(И($F$1>G19;$F$1<=G19);H19;0)+
ЕСЛИ(И($F$1>G20;$F$1<=G20);H20;0)+
ЕСЛИ(И($F$1>G21;$F$1<=G21);H21;0)+
ЕСЛИ(И($F$1>G22;$F$1<=G22);H22;0)+
ЕСЛИ(И($F$1>G23;$F$1<=G23);H23;0)+
ЕСЛИ($F$1>G24;H24;0)