Nested If - Maximum

M

Marshall Barton

jrcruzr said:
Is there another way to write nested if ? I have used 9 nested Ifs in my
formula and the tenth or more prompted: formula is too complex.
Click to expand...


Depends on what the nested IFs are doing.

Try using the ElseIf construct or, maybe better, Select
Case.
 
D

Duane Hookom

Most times that I have seen this many nested IIf()s, the solution is to use
data in lookup tables. I don't know if this is your situation.

Have you considered creating a user-defined function?
 
Top