zero values become negative notation

1 value of a cell minus another similar value of another cell = a negative 
value with a negative notation power.  Is this a bug? 


0
abc7550 (22)
5/11/2009 3:35:35 PM
excel 39879 articles. 2 followers. Follow

1 Replies
581 Views

Similar Articles

[PageSpeed] 34

Maybe the two values are not exactly the same. Could this be IEEE round-off 
error?
Chip's clear explanation
http://www.cpearson.com/excel/rounding.htm

Floating-point arithmetic may give inaccurate results in Excel 
http://support.microsoft.com/kb/78113/en-us

(Complete) Tutorial to Understand IEEE Floating-Point Errors 
http://support.microsoft.com/kb/42980

What Every Computer Scientist Should Know About Floating Point
http://docs.sun.com/source/806-3568/ncg_goldberg.html
http://www.cpearson.com/excel/rounding.htm

Visual Basic and Arithmetic Precision
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q279/7/55.ASP&NoWebContent=1

Others:
http://support.microsoft.com/kb/214118

http://docs.sun.com/source/806-3568/ncg_goldberg.html

-- 
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"crapit" <abc@mail.com> wrote in message 
news:u%23dOj4k0JHA.5728@TK2MSFTNGP03.phx.gbl...
>1 value of a cell minus another similar value of another cell = a negative 
>value with a negative notation power.  Is this a bug?
> 


0
bliengme (657)
5/11/2009 6:14:07 PM
Reply:

Similar Artilces: