Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to long error
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Too Long error | Excel Worksheet Functions | |||
formula is too long error | Excel Worksheet Functions | |||
Formula too long error... | Excel Discussion (Misc queries) | |||
Error formula too long | Excel Worksheet Functions | |||
formula too long error | Excel Discussion (Misc queries) |