How to calculate with exponential number?

[petercreateParticipant]

Hi, I have a column of exponential number, like 1.68E-09 …. I want to multiply 10^9 to the column and thus I can get 1.68…in a separate column. I tried 1.68E-09*E10 or 1.68E-09*(E10) or 1.68E-09*(E^10) or … What is the correct way to achieve that?

[dgteamModerator]

Hi – you can actually use the 10^9 notation directly or use 1E9.

Here is an example:

Is this what you mean?

[petercreateParticipant]

Thanks. Yes, that was what I wanted. Just realise I had to use 1E9 or 10^9 instead of E9 or E^9. 🙂

[Author]

Posts