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

Severino

Try formating A6 as "Number" instead of general.

Mike Rogers


"Severino" wrote:

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

This is called round-off error and results from the way computers convert
from decimal (base 10) to binary (base 2) numbers. See IEEE Binary Real
numbers Floating-Point
http://support.microsoft.com/kb/78113/en-us
This is common to most computer programs not just Excel
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"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

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