Thread: Matrix Inverse
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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