Formula Error

[Clarence]

Help with the formula calculation, it dosent calculate correct?

=SUM(24.35+14+12.1+10.05)+(12+12+16+16*0.52)*1.06

 

[Satish.digit]

The total is 111.7192 as per the formula how much your getting...?

 

[Luke M]

Also, if you're going to do the math yourself, you don't need the plus symbols. Or, leave out the SUM

=24.35+14+12.1+10.05+(12+12+16+16*0.52)*1.06

But as Satish said, why do you say it's not giving the correct result?

 

[Clarence]

Satish or Luke,

I'm coming up with 95.00 as the answer, heres how

24.35+14+12.1+10.05=60.50

12+12+16+16*0.52=29.12

60.50+29.12*1.06%=94.99

----------------------------

94.99

 

[Sajan]

Hi Clarence,

Excel evaluates the arithmetic operators in a specific sequence, with the "*" (multiplication) taking precedence over "+" (addition).


In your equation, Excel evaluates 16*.52 (to get a result of 8.32), before it continues with the addition.


Cheers,

Sajan.

 

[Hui]

Clarence


Using

=SUM(24.35+14+12.1+10.05)+(12+12+16+16*0.52)*1.06

(12+12+16+16*0.52) = 48.32

not as you had

(12+12+16+16)*0.52 = 29.12


The location of the bracket is critically important in these sort of problems


Also be careful using % in Excel

In a cell enter =1.06% and Excel will display 0.0106, not 1.06 as intended

Unless that's what you intended and left out of the first example

 

[Clarence]

Hui,

I may not be placing my numbers/brackets correctly,

what I'm trying to achieve is the following;

Adding up 24.35+14+12.1+10.05 to equal 60.50,

Adding up 12+12+16+16 to equal 56.00 and then multiplying it by .52 to equal 29.12

Finally multiplying 60.50 and 29.12 by 6%.

I get 94.99

 

[Hui]

So it should be:

=( SUM(24.35, 14, 12.1, 10.05) + Sum(12, 12, 16, 16)*0.52 )*1.06

or

=( (24.35 + 14 + 12.1 + 10.05) + (12 + 12 + 16 + 16)*0.52 )*1.06

 

[Clarence]

Hui,

Thanks so much, thats exactly what I was looking for.