Excel not adding correctly

Question

I have a simple spreadsheet in Excel&nbsp;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)&nbsp; but when I add all cells it is 2 cents off. any ideas?

detlef_lewin · Answer

Laurie,&nbsp;it sounds like a rounding or formatting issue.What number format are you using?&nbsp;And the SUM() function in your formula is totally superfluous.&nbsp;&nbsp;&nbsp;

laurie chaplin · Answer

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 .

laurie chaplin · Answer

by pages I mean workbook tabs of same but named different

detlef_lewin · Answer

Please provide a sample workbook with the problem.&nbsp;

laurie chaplin · Answer

DateToOdometerOdometerPurpose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Property NameMilesAmount8-JulGWMM - TNC-HSL124184124125Rent / ContractsTNC59.00$31.5720-JulGWMM - TNC-HSL124356124297Rent / PatrolTNC59.00$31.5725-JulGWMM - TNC-HSL124497124438Contracts / PatrolTNC59.00$31.5731-JulGWMM - TNC-HSL124777124696RentTNC81.00$43.34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total&nbsp;258.00$138.03

Forum Discussion

Excel not adding correctly

6 Replies

Resources

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