question regarding the IF formula
 

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.

question regarding the IF formula
 

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)


"Nelly" wrote in message
...
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.

question regarding the IF formula
 

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.
"Nelly" wrote in message
...
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.