multiple IF functions

[Luc]

Hi All,

I'm trying write an IF formula, but excel only allows 7 (i think) If's in a
string. What do i do if there are 10 or more IF's to choose from?

Thanks for any help,

Luc

 

[A.W.J. Ales]

Luc,

It is possible to divide your ifs in this way :


IF( CHOICE<5 , IF(CHOICE=1, IF(CHOICE=2,.........) , IF(CHOISE=6,
IF(CHOICE=7, .....)) )

but it is probably not the best solution.

Most likely it is better to review the logic and program in a different way.
As a start : Maybe you could take a look at the function CHOOSE( ).

If you need further help : explain the problem as close as you can (in words
; not in an attachement) and post it back.
Surely someone (if not me) will help you further.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *