PC Review


Reply
Thread Tools Rate Thread

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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple questions for simple 2 PC file sharing network. Simple? raylopez99 Microsoft Windows 2000 Networking 3 11th Feb 2007 02:31 PM
VISTA EUROPE : BUG BUG BUG. elien.rokes@yahoo.com Windows XP Help 0 11th Dec 2006 05:40 PM
Using a query for a simple calculation -- maybe not so simple =?Utf-8?B?Smlt?= Microsoft Access 3 30th Sep 2006 03:03 AM
know bug, bug, or me being stupid. Immediate cast bug.. PT Microsoft C# .NET 3 1st Aug 2006 10:35 PM
Simple Simple Simple craigwojo Microsoft Excel New Users 3 29th Aug 2004 05:32 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:23 AM.