To get a true sum
 

Help!

How do I get a true sum?

Ex:
A1 - 78,661.23
A2 - 3,612.66
A3 - 15,732.25
Total 98,006.13


The true sum should be 98,006.14, but it's giving me .13 instead of .14

--
Keep learning

To get a true sum
 

http://www.mcgimpsey.com/excel/pennyoff.html


--


Regards,


Peo Sjoblom


"shap-er" wrote in message
...
Help!

How do I get a true sum?

Ex:
A1 - 78,661.23
A2 - 3,612.66
A3 - 15,732.25
Total 98,006.13


The true sum should be 98,006.14, but it's giving me .13 instead of .14

--
Keep learning

To get a true sum
 

How did you get the numbers? Are they the result of some formula, and
you are just displaying them to 2dp? Try increasing the number of
decimals that are visible. You could make use of the ROUND function to
ensure those intermediate values are accurate.

Hope this helps.

Pete


On Dec 7, 5:08 pm, shap-er wrote:
Help!

How do I get a true sum?

Ex:
A1 - 78,661.23
A2 - 3,612.66
A3 - 15,732.25
Total 98,006.13

The true sum should be 98,006.14, but it's giving me .13 instead of .14

--
Keep learning