View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
R..VENKATARAMAN
 
Posts: n/a
Default What is the function opposite of LOG

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 10


LN 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

" wrote
in message ...
"erik" wrote:
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 "e" is not a reserved symbol in
Excel. Hence the need for EXP().