Summation Problem

[Ozam]

Can someone please tell me what is going on here? I've simply added four numbers together. Each number is taken to the hundreth. For some reason excel is adding other numbers way to the right of the decimal in the sum. I found this problem because it kept showing 0.00 rather than a dash (accounting format). Any ideas? Thanks


138,174.27000000000000000000
37,614.58000000000000000000
(171,712.80000000000000000000)
(4,076.05000000000000000000)
(0.0000000000118234311230481)

 

[Barrie Davidson]

Use the ROUND function in your formulae to round to the desired decimal places.
See http://support.microsoft.com/default.aspx?scid=kb;en-us;78113 for Microsoft's explanation/solution.

Regards,

 

[Ozam]

Thanks for your response. I understand the ROUND function. I was wondering whether anyone understands why EXCEL was adding information (albiet very small) to the sum - it was mathematically impossible!