Asked By
Cristine
10 points
N/A
Posted on - 09/08/2011
I am creating a formula for Social Security System Bracket computing.
In every row of the condition I have finished, I am testing the formula if the condition shows the right calculation for the salary bracket given.
I am just in the middle of the table when the error message showed as I enter the formula telling that the Formula is too long.
How can I avoid this error message since I need to create a long formula so that I could come up with the right answer?
Error:
Microsoft Excel
Formula is too long.
OK
How can Excel accept very long formula?
Hello Cristine,
Here's how I usually shorten formulas in Excel:
1. Make use of Excel functions.Â
Example 1: If you are adding several cells, instead of doing it this way: "=CELL1 + CELL2 + CELL3 + CELL4 + CELL5+…"
use the SUM() function like this: "=SUM(CELL1,CELL2,CELL3,…)".
Example 2:Â If you are performing average, use the AVERAGE() function instead of manually adding and dividing.
Example 3:Â "=a1*x1+a2*x2+a3*x3+a4*x4+a5*x5+a6*x6" can be written this way: "=SUMPRODUCT(A1:A6,X1:X6)".
2. Break down formulas into parts.
If your formula can be broken down into intermediate calculations, then do so. Place the intermediate results on other cells then just reference those cells on the main formula.
Here's an excellent guide that I refer to when I need help with Excel formulas
It might help you too.
Answered By
kimanif
0 points
N/A
#101681
How can Excel accept very long formula?
I wish i can see the formula to give you assistance. You should know that you can enter or next 64 levels of a function within a function.
Even if you collapse the formula bar, still the rule above holds.
The solution to this is to break the formula to sub formulae that can be calculated within the parenthesis you will set without making sure that the original formula will not result to some thing different.
Each of the sub formulae on their individual cells. Lastly form the last formula to be composed of the all sub formulae.
How can Excel accept very long formula?
Hi Cristine
Text contents up to 30,000 or more characters long. Your text formula use in 1 half method. Anyway, check out this Techyv post to get more idea.Â
Microsoft Excel Formula is too long.
