Nested If - Maximum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Thank you,
(e-mail address removed)
 
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.
 
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?
 
Back
Top