anti logarithm function for base 10

[Guest]

Does Excel 2000 have an antilogarithm function for base 10. For example, the
log to the base 10 of 5 is .69897.... What is the name of teh function that
is used to convert .69896.. back into 5?

 

[Ken Johnson]

Just 10^.69897....
Ken Johnson

 

[Guest]

You don't actually need a special formula for that!
For example, you got the 0.698970004 in cell A1,
in A2, you type:
=10^A1
And you'll get 5.

That is, the formula:
=10^LOG10(5)
will return 5.

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[Guest]

Thank you Edwin Tam

You don't actually need a special formula for that!
For example, you got the 0.698970004 in cell A1,
in A2, you type:
=10^A1
And you'll get 5.

That is, the formula:
=10^LOG10(5)
will return 5.

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[Guest]

Thank you Ken Johnson

 

[Ken Johnson]

Hi CJ,

That was posted Easter Sunday.
That's a very slow resurrection;-)
CJ = Christ Jesus?

I apologise if I offend.

Ken Johnson