# Simple Calculation Bug

Mehmet Esen
Guest
Posts: n/a

 3rd Jun 2012
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?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post raylopez99 Microsoft Windows 2000 Networking 3 11th Feb 2007 02:31 PM elien.rokes@yahoo.com Windows XP Help 0 11th Dec 2006 05:40 PM =?Utf-8?B?Smlt?= Microsoft Access 3 30th Sep 2006 03:03 AM PT Microsoft C# .NET 3 1st Aug 2006 10:35 PM craigwojo Microsoft Excel New Users 3 29th Aug 2004 05:32 AM

Features