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?

Just 10^.69897....
Ken Johnson

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

http://www.vonixx.com


"CJ" wrote:

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?

Thank you Edwin Tam

"Edwin Tam" wrote:

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

http://www.vonixx.com


"CJ" wrote:

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?

Thank you Ken Johnson

"Ken Johnson" wrote:

Just 10^.69897....
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