Formula is too long

[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

 

[Bill Ridgeway]

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

 

[Bob Phillips]

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)

 

[Bill Ridgeway]

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

 

[kras]

Thank you both Bill and Bob.

 

[Bob Phillips]

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)

 

[Bill Ridgeway]

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