=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,I 3,0))))))))

Perhaps a better, simpler alternative to achieve the above ..
(wo being limited by the max nested IFs)
is to use something like this in say, T1:
=IF(S1="","",INDEX(B3:IV3,,S1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wan" wrote:

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