Summation Problem

Ozam

New Member
Joined
Sep 10, 2002
Messages
15
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)
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Ozam

New Member
Joined
Sep 10, 2002
Messages
15
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,706
Members
412,481
Latest member
nhantam
Top