I don't understand the meaning of E in an answer given by Excel or Calculator
For example: 7.57629E-08
What does E in the above answer mean?
I don't understand the meaning of E in an answer given by Excel or Calculator
For example: 7.57629E-08
What does E in the above answer mean?
from the Excel Help files (power of reading - they exist!!)
This format displays a number in exponential notation, replacing part of the number with E+n, where E (which stands for Exponent) multiplies the preceding number by 10 to the nth power. For example, a 2-decimal Scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power. You can specify the number of decimal places that you want to use.
see also: http://office.microsoft.com/en-us/ex...641321033.aspx
in your case the value is 0.0000000758
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks