Explain 2.178E-11
 

--
Ron
Perth
Western Australia

Explain 2.178E-11
 

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
---------------
Jacob Skaria


"RonG" wrote:


--
Ron
Perth
Western Australia

Explain 2.178E-11
 

which is 0.00000000002178

Jacob Skaria;438216 Wrote:
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
---------------
Jacob Skaria


"RonG" wrote:


--
Ron
Perth
Western Australia


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121613

Explain 2.178E-11
 

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/default...NoWebContent=1

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

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

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


"RonG" wrote in message
...

--
Ron
Perth
Western Australia

Explain 2.178E-11
 

Bernard Liengme;438532 Wrote:
A man of few words!

..and none of them 'please'.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121613