Not adding up

[Theresa]

In accounting format Excel is coming up with inaccurate
answers 30,784.00
-16,611.49
___________
14,172.52? This should be 14,172.51, and

25,655.28
84,483.40
+12,829.37
__________
122,968.04? This should this be 122,968.05.
Am I doing something wrong here?
Thanks for your help

 

[Ken Wright]

Accounting format does merely that - FORMATS. Formatting affects what you see
visually and does not change the undelying data. You can either round the
values that you are summing, eg the 25,655.28 etc using the ROUND function, or
you can use the ROUND function in your summation formula and array enter it,
eg:-

instead of =SUM(A1:A5)

=SUM(ROUND(A1:A5,2))

array entered using CTRL+SHIFT+ENTER, which as long as you have done it
correctly will appear with curly braces

{=SUM(ROUND(A1:A5,2))}

You cannot enter these braces manually and must do it as I have stated.

There is another option called Precision as displayed that can be turned on, and
all numbers will be treated exactly as you see them, but it will truncate data
and you cannot get that detail back. I just hate doing this, but if you wanted
to it is in Tools / Options / Calculation / Precision as displayed

 

[Peter Atherton]

Theresa

Probabley a rounding problem.

Price VAT @ 17.5% Total Price
34.47 6.03225 40.50225

Formula for VAT should be =ROUND(B9*17.5%,2) resulting in

34.47 6.03 40.5

Regards
Peter