Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the function opposite of LOG
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function is the opposite of SUM? | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |