Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple arithmetic
On Mon, 24 Jan 2005 17:35:21 -0000, "Pat" wrote:
Is the formula wrong or am I wrong? The formula is doing what it should do according to Excel's rules of precedence. The SUM function is superfluous. In order to obtain the result you posted, you need to rearrange your parentheses to match the order of calculation precedence in your (manual) calculation: =(AR32*AU32+AR32)/1.4+(AS32*AU32+AS32) --ron |
#2
|
|||
|
|||
You have to pay attention to the order of evaluation within any aritjmentic
formula. Multiplication and division are performed before addition and subtraction. If you insert a ) before the division sign, to force adding AR32 before dividing by 1.4, then you get the answer 4.028571429 Your original formula add 4.70/1.4 to 4.70*.2, and then adds the second term, which is zero. The answer you get all depends on what expression you really want to evaluate. On Mon, 24 Jan 2005 17:35:21 -0000, "Pat" wrote: Here is a simple arithmetic question =SUM((AR32*AU32+AR32/1.4)+(AS32*AU32+AS32)) Each of the cell contain the following values: AR32 = 4.70 AU32 = 20% AS32 = 0.00 The current formula will return: 4.30 The correct answer according to my calculations is 4.028 Is the formula wrong or am I wrong? Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Excel user needs help with simple Macro... | New Users to Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
A simple maco . . . | New Users to Excel | |||
Simple, Monday morning brain function | Excel Worksheet Functions |