Total Does Not Match With Sum of Values in Each Cell

[mvkale]

Hello,
I am preparing a sheet of Stock Trading and I have entered the formulae for all the expenses related to stock purchases. Sometimes the amounts are in fraction. When I compare the values in each cell those match exactly with the statement provided by my stock dealer. However, When I take the total of those individual cells with a sum formula then there those do not match.

For example -
Expense A - 0.01
Expense B - 0.22
Expense C - 0.04
Expense D - 7
Expense E - 0.01
Expense F - 0.68

These total individually match with the statement provided by my stock dealer but if I put a formula of Sum(Expense A:Expense F) total comes to 7.78 instead of 7.96

In above cells wherever there is a fraction I have set decimal places to 2; maybe because of this I am having a problem.

Please let me know how can I make the total look like 7.78 instead of 7.96.

 

[Michael M]

Changing decimals to 2 places is visual only....the calculation will be for all decimal places regardless of what appears !

 

[AlanY]

instead of setting the decimal places, use the ROUND() to 2 digits before summing up

 

[mvkale]

instead of setting the decimal places, use the ROUND() to 2 digits before summing up

Hi, thanks for the reply. Wouldn't that remove the digits after decimal? I need digits after decimal as well. What am I missing out on?

 

[AlanY]

got it?

Book1
	A	B	C
1	3.141593	3.14	3140
Sheet2

Cell Formulas
Range	Formula
A1	=PI()
B1	=ROUND(A1,2)
C1	=B1*1000

 

[mvkale]

Oh great. Thanks a lot. Now I feel like a silly.

 

[AlanY]

you're welcome
don't worry, we all been there