anti logarithm function for base 10

CJ · Apr 16, 2006

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 · Apr 16, 2006

Just 10^.69897....
Ken Johnson

Edwin Tam · Apr 16, 2006

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
[email protected]
http://www.vonixx.com

CJ · May 6, 2006

Thank you Edwin Tam

Edwin Tam said:
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
[email protected]
http://www.vonixx.com

CJ · May 6, 2006

Thank you Ken Johnson

Ken Johnson · May 6, 2006

Hi CJ,

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

I apologise if I offend.

Ken Johnson