question regarding the IF formula

[Guest]

Hi:

Did anyone know if there is a way to add more than 7 nested IF's on the same
formula?? I really need to add more than 7 but excel didn't let me.

Or did someone of you know another option (method, function) to have several
IF on the same formula?

Thanks for your help!
Nelly Montalvo.

 

[Bob Phillips]

There are ways, but it depends upon what you are doing. Give some details.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Alan]

No you cant use more than seven nested IF's. One way round it is to use
VLOOKUP. Put all the criteria into say G1:G20, then in F1:F20 enter 1,2,3
etc,
then use something like =VLOOKUP(A1,F1:G20,2,FALSE)
Checkout VLOOKUP in Help, its all there, or Google search it, you'll find
loads of examples,
Regards,
Alan.