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

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