Matrix Inverse
When i was doing the matrix inverse for my assignment, two of the cell have
values like this (3.111E-05). I want to know what does the E means and how can i fix this problem. -- Thnx for the help |
Matrix Inverse
3.111E-05 is a shorthand way of writing 3.111 * 10^-5
-- David Biddulph "Rosina" wrote in message ... When i was doing the matrix inverse for my assignment, two of the cell have values like this (3.111E-05). I want to know what does the E means and how can i fix this problem. -- Thnx for the help |
Matrix Inverse
there is nothing wrong: this is just a notation for representing very small
or very large numbers. From Excel HELP: The Scientific 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. 3.111E-05= 0.00003111. (3.111 divided by 100000 i.e 3.111 / 10 to 5th power) Click on the cell containing this number and you will see 0.00003111 in the formula bar. HTH "Rosina" wrote: When i was doing the matrix inverse for my assignment, two of the cell have values like this (3.111E-05). I want to know what does the E means and how can i fix this problem. -- Thnx for the help |
All times are GMT +1. The time now is 02:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com