View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Excel 2003 Calculation Error

Not an error, but merely that binary representation won't represent a number
like 70.41 exactly (just as decimal won't represent 1/3 exactly, but will
approximate it as 0.33333 ... with however many decimal places you choose to
use).

Try these links as a starting point for further information:
http://support.microsoft.com/kb/78113
http://support.microsoft.com/kb/214118
http://www.cpearson.com/excel/rounding.htm

As an excercise, try to work out the binary representation for your
114470.41, then you'll start to understand what Excel is doing.
--
David Biddulph

"Severino" wrote in message
...
Hi,
I found a Calculation error in Excel 2003.

A1 = 114470.41
A2 = 114400.00
A3 = 70.41

A5 = A1 -A2
A6 = A3 - A5

Note: Excel is suppose to give as result 0.00, however it's giving
(-3.49587025993969E-12)'

Can I get an answer on this? if there is a way that can be resolve or will
be resolve in the future.
--
Knowledge is just a Tool! There is more to live for!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc