Problem with nested if function. PLS HELP

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

"sfar007" <[email protected]> wrote in
message news:[email protected]...
>
>
>
> 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",""))))))
--
David Biddulph

thanks a lot dave. it works