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
- Dec 18 Mon 2006 20:34
anti logarithm function for base 10
close
全站熱搜
留言列表
發表留言