Problem with nested if function. PLS HELP
:confused: 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 |
Problem with nested if function. PLS HELP
"sfar007" wrote in
message ... :confused: 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 |
Problem with nested if function. PLS HELP
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 |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com