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