| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Explain 2.178E-11
-- Ron Perth Western Australia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Explain THIS ... | Excel Discussion (Misc queries) | |||
| explain this one to me.... | Excel Discussion (Misc queries) | |||
| Please explain | Excel Worksheet Functions | |||
| How to explain??... | Excel Discussion (Misc queries) | |||
| Let me see if I can explain this... | Excel Worksheet Functions | |||
Linear Mode
