A value in an excel cell is 1.234E 05. What is equal to it?
The value of a certain cell is 1.234E 05, which is equal to 123400.
1.234E 05 is an expression of scientific notation in Excel
1.234E+0.5=1.234×10^5=1.234×100000=123400
E 05 is an expression of scientific notation in Excel
Recommended tutorial: excel tutorial
Extended information:
Represent a number in the form of a multiplied by 10 raised to the nth power (1≤|a|
The form of scientific notation:
The form of scientific notation is composed of the product of two numbers. Expressed as a×10^b (aEb)
One of the factors is a (1≤|a|<10), and the other factor is 10^n.
Scientific notation facilitates counting:
When using scientific notation to express numbers, the symbol of the number is not changed, but the writing form of the number is changed. It can be conveniently expressed in daily life. Some very large or small numbers. For example: the speed of light is about 300,000,000 meters/second; the world's population is about: 6,100,000,000.
Such numbers are very inconvenient to read and write. We can avoid writing so many repeated zeros. Express it in the form: 6,100,000,000=6.1×10^9,
or: 0.00001=1×10^-5, that is, a number with an absolute value less than 1 can also be expressed as a using scientific notation. Multiply 10 to the negative nth power.
The above is the detailed content of What is the equivalent of a value in an excel cell 1.234E+05?. For more information, please follow other related articles on the PHP Chinese website!