AND Statements

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Is there a limit aqs to how many AND statements can be used in a formula?

I believe there is a limit of 9 for the number of nested if statements in a
formula.

Andrew
 
Andrew said:
Is there a limit aqs to how many AND statements can be used in a formula?
Click to expand...

AFAIK no, not until you reach the max limit for a formula length.
I believe there is a limit of 9 for the number of nested if statements in a
formula.
Click to expand...

7 nested IFs is the maximum. There are usually better solutions for those
situations than IFs.

HTH. Best wishes Harald
 
Back
Top