How can Excel accept very long formula?

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

• Status: Open
• Question Views: 1511
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Patrick b

Go To Solution

Best Answer

Best Answer

Answered By Patrick b 0 points N/A #101680

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.

About Patrick b

Questions
0

Answers
107

Best Answers
38

• Vote Up 0 Vote Down

• Posted on - 09/08/2011
• Question Category: MS Excel

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.

About kimanif

Questions
0

Answers
50

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 09/08/2011
• Question Category: MS Excel

Answered By George W Sperling 0 points N/A #101682

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.

About George W Sperling

Questions
5

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/08/2014
• Question Category: MS Excel