Matrix Inverse

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top