Hi all,
I have done if function with 8 argurement/condition with no problem.Is
there
anyway for me to have more than 8 condition using if function?

here is the example,
=IF($S$1=1,B3,IF($S$1=2,C3,IF($S$1=3,D3,IF($S$1=4, E3,IF($S$1=5,F3,IF($S$1=6,G3,IF($S$1=7,H3,IF($S$1= 8,I3,0))))))))

cheers

Wan


--
wan
------------------------------------------------------------------------
wan's Profile: http://www.excelforum.com/member.php...o&userid=37523
View this thread: http://www.excelforum.com/showthread...hreadid=571675