Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question | Excel Discussion (Misc queries) | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |