Nested IFs ( Excel 2003 )

Topic

New Reply

Hi

I have the following formula in column B, is there a more effecient formula than the Nested IFs

=IF(A2<=0.2,18,IF(A2<=0.22,16,IF(A2<=0.25,14,IF(A2<=0.28,12,IF(A2<=0.32,10,IF(A2<=0.35,8,IF(A2<=0.38,4,0)))))))

pls see attached

TIA

Reply | Quote

Replies

You can use a VLOOKUP function. The bonus in this is that you can go beyond the 7 nest limit.

See the attached example.

Reply | Quote

Rudi

Thanks, should have think of this

Reply | Quote