Hi,

I need some help with the nested if function.

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

My problem is with the nested if function in the adjacent cell (K225):
=IF(J22530,"5",IF(J22526.5,"4",IF(J22520.5,"3", IF(J22517.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
------------------------------------------------------------------------
sfar007's Profile: http://www.excelforum.com/member.php...o&userid=35131
View this thread: http://www.excelforum.com/showthread...hreadid=548890

"sfar007" wrote in
message ...



Hi,

I need some help with the nested if function.

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

My problem is with the nested if function in the adjacent cell (K225):
=IF(J22530,"5",IF(J22526.5,"4",IF(J22520.5,"3", IF(J22517.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(J22530,"5",IF(J22526.5,"4",IF( J22520.5,"3",IF(J22517.49999999,"2",IF(J225=1," 1",""))))))
--
David Biddulph

thanks a lot dave. it works :)


--
sfar007
------------------------------------------------------------------------
sfar007's Profile: http://www.excelforum.com/member.php...o&userid=35131
View this thread: http://www.excelforum.com/showthread...hreadid=548890