What is the function (and where can I find it) opposite of LOG, e.g.
Inverse Log(Log10) = 10)?
-Erikquot;erikquot; wrote:
gt; What is the function (and where can I find it) opposite of LOG
No function needed. The inverse log is simply the base raised
to the power of the logarithm. In the case of LOG(), the base
is 10. So 10^LOG(x) = x.
Likewise, e^LN(X) = X. But quot;equot; is not a reserved symbol in
Excel. Hence the need for EXP().depends upton
log(10,10) is 1
reverse is power functin
10 to the power 1(a0^1) is10
simialrly log(10,2) is 3.321928
so 2^3.321928 is 10LN is the log to the base e(exponetial)
LN(86) is 4.454347
exp is the worksheet function for exponential
exp(4.454347) is 86
see excel help for these functions
quot; gt; wrote
in message ...
gt; quot;erikquot; wrote:
gt;gt; What is the function (and where can I find it) opposite of LOG
gt;
gt; No function needed. The inverse log is simply the base raised
gt; to the power of the logarithm. In the case of LOG(), the base
gt; is 10. So 10^LOG(x) = x.
gt;
gt; Likewise, e^LN(X) = X. But quot;equot; is not a reserved symbol in
gt; Excel. Hence the need for EXP().
gt;
quot;R..VENKATARAMANquot; wrote:
gt; quot; wrote:
gt; gt; In the case of LOG(), the base is 10. So 10^LOG(x) = x.
gt;
gt; depends upton
gt; log(10,10) is 1
gt; reverse is power functin 10 to the power 1(a0^1) is10
gt;
gt; simialrly log(10,2) is 3.321928
gt; so 2^3.321928 is 10
gt; [....]
gt; see excel help for these functions
Yes, __do__ read the Help text. I wrote quot;LOG(x)quot; with no
quot;basequot; parameter. The default base is 10. So while it is
true that you may specify other bases, what I wrote was
not incorrect for base 10.
I interpreted the OP's question to be about log to base 10. I
mentioned LN() only to explain why the OP might have found
EXP(), which I thought might have set his expectation for
something comparable for LOG().
- Jul 25 Fri 2008 20:45
What is the function opposite of LOG
close
全站熱搜
留言列表
發表留言
留言列表

