Calculating figures using nested If statements

A

Allan F

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
 
S

Sue Mosher [MVP-Outlook]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

solving nested IF statements 16
calculations in nested if statements 1
Calculations inside nested if statements 4
NESTED ANDIF STATEMENTS 1
UDFunctions and nested If-the-else statements 1
Too Many Nested IF Statements! 5
Nested IIF problem 2
Nested IF statements 0

Top