Good Morning -
I have a Long Formula that I use -- I have had to divide it into two Cells and then Combine the results to display in a third Cell.
I am close to the Maximum Formula Length on both of the Work Cells - Trying to add even a few more characters to either results in a "Formula too Long" Message.
I'm Puzzled - the formula in the First Work Cell is Much Longer than the Formula in the Second. It has more Cell Refrences - More Text - More Functions yet both are right at the Maximum before recieving the "Formula too Long" Message.
In the past I have seen some massive formulas displayed here in threads that are shown without reference to being divided or being too long.
Can Anyone help me to understand how that is Calculated - and,
Can that Length Setting be Changed Somehow ??
I'd like to add some text to what I have and would like to do it without using another Column.
Thanks ( 3AM here - will look in in the morning )
WIN XP SP3 EXCEL 2002 SP3
I have a Long Formula that I use -- I have had to divide it into two Cells and then Combine the results to display in a third Cell.
I am close to the Maximum Formula Length on both of the Work Cells - Trying to add even a few more characters to either results in a "Formula too Long" Message.
I'm Puzzled - the formula in the First Work Cell is Much Longer than the Formula in the Second. It has more Cell Refrences - More Text - More Functions yet both are right at the Maximum before recieving the "Formula too Long" Message.
In the past I have seen some massive formulas displayed here in threads that are shown without reference to being divided or being too long.
Can Anyone help me to understand how that is Calculated - and,
Can that Length Setting be Changed Somehow ??
I'd like to add some text to what I have and would like to do it without using another Column.
Thanks ( 3AM here - will look in in the morning )
WIN XP SP3 EXCEL 2002 SP3