Formula is too long

  • Thread starter Thread starter kras
  • Start date Start date
K

kras

When I write a formula, that is truly long, I recieve a message "Formul
is too long". Is there a way to remove this limitation so that I coul
write long formulas?

Any help is welcome.

kra
 
There is no way (as far as I am aware) of removing the limitation.

A work round would be to have two additional columns. Columns A and B
should have parts of your formula which result in either a ('TRUE' or
'FALSE') or a figure or 0(zero). Column C should have pick up the required
result from either A or B and is, in effect, the output from your formula.

Regards.

Bill Ridgeway
Computer Solutions
 
You cannot remove the limitation, but another way is to create workbook
names (Insert>Name>define...) for the long bits of formulae or repeated
parts with some short snappy name and a RefersTo value of that formula part,
and use the name in the worksheet formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Bob suggested that you could <<create workbook names (Insert>Name>define...)
for the long bits of formulae or repeated>>.

This would work if the problem was reaching the maximum numbers of
characters allowed in a formula. However, I have often reached the maximum
number of arguments (IF etc) before reaching the maximum number of
characters which is addressed by my solution.

Regards.

Bill Ridgeway
Computer Solutions
 
Formula is too long is too many characters Bill, the other problem would
throw an 'the formula you typed contains an error ' (which is less than
helpful).

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Naming cells would reduce the number of characters to an 'acceptable length.
If it is still too long I would suggest my solution.

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top