Simple Calculation Bug

[Mehmet Esen]

Let's see the table (A111) below:

A B C D
1 IN OUT BALANCE
2 0 0 =+B3-C3
3 29000 =+D3+B4-C4
4 13218.78 =+D4+B5-C5
5 14855.43 =+D5+B6-C6
6 350 =+D6+B7-C7
7 575.79 =+D7+B8-C8
8 =+D8+B9-C9
9 =+D9+B10-C10
10
11 =SUM(B3:B11) =SUM(C3:C11)

This simple calculation returns the figures such as:

A B C D
1 IN OUT BALANCE
2 - - -
3 29,000.00 29,000.000000000000000
4 13,218.78 15,781.220000000000000
5 14,855.43 925.789999999999000
6 350.00 575.789999999999000
7 575.79 (0.000000000000909)
8 (0.000000000000909)
9 (0.000000000000909)
10
11 29,000.00 29,000.000

Even if we calculate in a cell : +15781.22 - 14855.43 returns to
925.78999999999900

How can I fix this bug?

 

[Ron Rosenfeld]

Let's see the table (A111) below:

A B C D
1 IN OUT BALANCE
2 0 0 =+B3-C3
3 29000 =+D3+B4-C4
4 13218.78 =+D4+B5-C5
5 14855.43 =+D5+B6-C6
6 350 =+D6+B7-C7
7 575.79 =+D7+B8-C8
8 =+D8+B9-C9
9 =+D9+B10-C10
10
11 =SUM(B3:B11) =SUM(C3:C11)

This simple calculation returns the figures such as:

A B C D
1 IN OUT BALANCE
2 - - -
3 29,000.00 29,000.000000000000000
4 13,218.78 15,781.220000000000000
5 14,855.43 925.789999999999000
6 350.00 575.789999999999000
7 575.79 (0.000000000000909)
8 (0.000000000000909)
9 (0.000000000000909)
10
11 29,000.00 29,000.000

Even if we calculate in a cell : +15781.22 - 14855.43 returns to
925.78999999999900

How can I fix this bug?

You can find thousands of discussion of this issue on the web, with a little searching.

If you require a particular level of precision, you can round to your desired level of precision.

See MSKB Article 214118 for details. http://support.microsoft.com/kb/214118