close

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 JohnsonYou 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

www.vonixx.comquot;CJquot; wrote:

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

Thank you Edwin Tam

quot;Edwin Tamquot; wrote:

gt; You don't actually need a special formula for that!
gt; For example, you got the 0.698970004 in cell A1,
gt; in A2, you type:
gt; =10^A1
gt; And you'll get 5.
gt;
gt; That is, the formula:
gt; =10^LOG10(5)
gt; will return 5.
gt;
gt; Regards,
gt; Edwin Tam
gt;
gt; www.vonixx.com
gt;
gt;
gt; quot;CJquot; wrote:
gt;
gt; gt; Does Excel 2000 have an antilogarithm function for base 10. For example, the
gt; gt; log to the base 10 of 5 is .69897.... What is the name of teh function that
gt; gt; is used to convert .69896.. back into 5?

Thank you Ken Johnson

quot;Ken Johnsonquot; wrote:

gt; Just 10^.69897....
gt; Ken Johnson
gt;
gt;

Hi CJ,

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

I apologise if I offend.

Ken Johnson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()