+ Reply to Thread
Results 1 to 4 of 4

What is the function opposite of LOG

  1. #1
    erik
    Guest

    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
    [email protected]

  2. #2

    RE: 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. #3
    R..VENKATARAMAN
    Guest

    Re: 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

    "[email protected]" <[email protected]> wrote
    in message news:[email protected]...
    > "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. #4

    Re: What is the function opposite of LOG

    "R..VENKATARAMAN" wrote:
    > "[email protected]" 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1