Error - Formula too long

  • Thread starter Thread starter Ritu Arora
  • Start date Start date
R

Ritu Arora

I am writing a formula - the length of which is exceeding
1024 chars. Is it possible to do so ? I am getting an
error message - Formula Too Long. I am using Excel 2000
 
Formula length is limited. If you post the formula
someone can probably offer a suggestion on how it can be
shortened.

PC
 
Ritu Arora said:
I am writing a formula - the length of which is exceeding
1024 chars. Is it possible to do so ? I am getting an
error message - Formula Too Long. I am using Excel 2000
Click to expand...

1024 characters is the limit.
Formulas that long are unwieldy anyway, and very difficult to understand and
maintain.

There are obvious things to avoid this, like using shorter sheet names.
Apart from that, it may well be that what you are trying to do can be done
more elegantly, so shortening the formula considerably. Post back with some
details for help with this.
 
Back
Top