Excel not adding correctly

[Laurie Chaplin]

I have a simple spreadsheet in Excel that I use for mileage. My column that I am adding is not adding correctly, I have reentered my formulus, I have used my sum for the end column and it still continues to be 2 cents off. I have ran all the issues, and combatibility. If I manually just enter the figure I get the correct number end result, but not if it is using the formula in each cells total. I reentered the formula and it isnt that. can anyone help me. Formula is =SUM(G11*0.535)  but when I add all cells it is 2 cents off. any ideas?

[#2]

Laurie,

it sounds like a rounding or formatting issue.

What number format are you using?

And the SUM() function in your formula is totally superfluous.

[#3]

That's what I thought but its not doing it on all my pages. and what do you mean number format? I have tried accounting, currency and number .

[#4]

by pages I mean workbook tabs of same but named different

[#5]

Please provide a sample workbook with the problem.

[#6]

Date	To	Odometer	Odometer	Purpose	Property Name	Miles	Amount
8-Jul	GWMM - TNC-HSL	124184	124125	Rent / Contracts	TNC	59.00	$31.57
20-Jul	GWMM - TNC-HSL	124356	124297	Rent / Patrol	TNC	59.00	$31.57
25-Jul	GWMM - TNC-HSL	124497	124438	Contracts / Patrol	TNC	59.00	$31.57
31-Jul	GWMM - TNC-HSL	124777	124696	Rent	TNC	81.00	$43.34
				Total		258.00	$138.03

[#7]

It looks like typical "few cents gap" accountants issue. What they do to avoid it that's round all intermediate calculations. And that's what we have in real life - we don't pay $10.25612 as calculation shows, we pay $10.26. After we sum all transactions as the latest we have correct figure for how much we spent totally.