Calculating figures using nested If statements

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

Guest

In Outlook 2003, when trying to calculate a fugure, while setting the Initial
Value, I enter a formula which consists of 9 nested If-statements. For some
reason, it accepts 7 but not the 8th or 9th. It provides the following
error: "Missing operand before comma, ), or operator".

I do not believe that I am missing anything. Are there limitations on how
many If-statements that I can use?

Thank-you
 
Maybe you reached the undocumented size/complexity limit for such formulas.
9 nested IIf statements is certainly beyond my own debugging limit. I'd
write code instead.
 
Back
Top