Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
erik
 
Posts: n/a
Default What is the function opposite of LOG

What is the function (and where can I find it) opposite of LOG, e.g.
Inverse Log(Log10) = 10)?
-Erik

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

"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().

  #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().




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

"R..VENKATARAMAN" wrote:
" wrote:
In the case of LOG(), the base is 10. So 10^LOG(x) = x.


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
[....]
see excel help for these functions


Yes, __do__ read the Help text. I wrote "LOG(x)" with no
"base" 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().

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What function is the opposite of SUM? rsilver Excel Discussion (Misc queries) 4 November 19th 05 06:56 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"