Nested IF statement

[jgannon]

Excel only allows 7 nested If statements, is there a way around this?

 

[Guest]

Without more information, (Like exactly what are you trying to do that you
need more than seven nested if statements?) I can't help you. BUT you might
try spreading out your function over more than one column, such that the
output of one function gives an incomplete result, which is completed by the
formula next to it.

 

[BenjieLop]

Excel only allows 7 nested If statements, is there a way around this?

*VLOOKUP* is usually a good alternative (in most cases).

Regards.

 

[Ron Coderre]

Depending on your situation, you may be able to use one of the more
typical "workarounds".....a lookup table.

Example:
If you want your formula to return a department name based on its
DeptID, as in ...
IF A1=101, Return "A/R"
IF A1=102, Return "Shipping"
IF A1=103, Return "Maintenance"
IF A1=104, Return "Finance"
IF A1=105, Return "Security"
IF A1=106, Return "Tax"
IF A1=107, Return "Systems"
IF A1=108, Return "Treasury"
IF A1=109, Return "Admin"

You'd create a list (probably on another worksheet, say Sheet2) like
this:

ROW____COL_A_________COL_B
1_______101___________A/R
2_______102___________Shipping
3_______103___________Maintenance
4_______104___________Finance
5_______105___________Security
6_______106___________Tax
7_______107___________Systems
8_______108___________Treasury
9_______109___________Admin

Now, on Sheet 1:
A1: 106
B1: =VLOOKUP(A1,Sheet2!A1:B9,2,0)
(returns the value that corresponds to DeptID 106-->Tax)

Something you could use? Or is your situation more complicated?

Regards,
Ron