Maybe it can be re-written. Post it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bradmcq" wrote in message
...
Hi, I have a long if formula in excel, but can't finish as I get the
error
that the formula is too long. Is there any way to extend the length a
formula can be?

Otherwise I guess the only way around it is to put parts of the formula in
other cells?,

or

As a big part of the formula repeats, as the logic part of the if can you
create a name for a formula and store it as a macro or somewhere else and
refer to it as the name in the if statement to reduce the length ?