Problem with nested if function. PLS HELP

[sfar007]

Hi,

I need some help with the nested if function.

In one cell (J225), i have the following function (which works
perfectly):
=IF(AND(H225>0,F225>0),SUM(F225/I225),"")

My problem is with the nested if function in the adjacent cell (K225):
=IF(J225>30,"5",IF(J225>26.5,"4",IF(J225>20.5,"3",IF(J225>17.49999999,"2",IF(J225>=1,"1","")))))

Whenever J225 is blank, the result in K225 should also remain blank.
However, this is not the case as the result is coming out as "5".

Please note, that if i remove the 1st function (J225), the 2nd function
(K225) works perfectly!!!

thanks

 

[David Biddulph]

Hi,

I need some help with the nested if function.

In one cell (J225), i have the following function (which works
perfectly):
=IF(AND(H225>0,F225>0),SUM(F225/I225),"")

My problem is with the nested if function in the adjacent cell (K225):
=IF(J225>30,"5",IF(J225>26.5,"4",IF(J225>20.5,"3",IF(J225>17.49999999,"2",IF(J225>=1,"1","")))))

Whenever J225 is blank, the result in K225 should also remain blank.
However, this is not the case as the result is coming out as "5".

Please note, that if i remove the 1st function (J225), the 2nd function
(K225) works perfectly!!!

=IF(J225="","",IF(J225>30,"5",IF(J225>26.5,"4",IF(J225>20.5,"3",IF(J225>17.49999999,"2",IF(J225>=1,"1",""))))))

 

[sfar007]

thanks a lot dave. it works