maximum number of characters within a forumla?

B

B G

I have a formula that I keep getting an error on - is there a maximum number
of characters allowed in a formula. It keeps highlighting "IF" and won't
allow me to complete the formula.
 
B

Bill Ridgeway

I've found that the complexity of the formula (number of arguments and
nesting) that is more limiting than the number of characters.

Regards.

Bill Ridgeway
Computer Solutions
 
G

Gord Dibben

Could be either of two limits.

1. 1024 character limit for formulas.

2. 7 nested "IF",s in a formula.

See Help on "limits and specifications" for other parameters.


Gord Dibben MS Excel MVP
 
Top