Explain 2.178E-11

[RonG]

--
Ron
Perth
Western Australia

 

[Jacob Skaria]

The capital E is for 10 raised to power. 2.178E-11 is 2.178 times 10 raised
to power -11

OR

=2.178*10^-11

If this post helps click Yes

 

[Bernard Liengme]

A man of few words!
Are you perhaps concerned that you got this value when you were expecting
zero.
If so you may wish to lean about the problems if the IEEE convention that
most computer program (not COBOL) use to store numbers
IEEE 754
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/defaul...port/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

best wishes