Results 1 to 5 of 5

Thread: Antilog?

  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Lounger - I've started doing some statistical training that involved logs and antilogs

    I have found the log calculaton but not sure where or how to calculate antilogs

    Still new at this, but of anyone has any ideas would be please to get some advise

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Working with a number A and to the base B:

    Log A to the base B is =LOG(B,A)

    Antilog A to the base B is =B^A

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In addition to Martin's reply:

    If you omit the base argument of the log function, you get the base 10 logarithm. For example =LOG(1000) will return 3.
    The inverse of this is =10^... or =POWER(10,...)

    Mathematicians often use logarithms with base e ~ 2.71828.
    There is a special function for this: LN, with inverse EXP.

    So =LN(45) is equivalent to =LOG(45,e) and =EXP(3) is equivalent to =e^3.


  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Thanks for the reply.

    Following on from your info - (I haven't had to do this for a long time and when I did it was'nt using excel)

    In A1 i have 2, in B2 I have =Log(A1,10) giving the result 0.301029996

    To Antilog A1 (2) in say B3, what formula would I use (is the ^ on shift 6 the correct symbol?)

    Thank for any assistance

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Quote Originally Posted by verada View Post
    To Antilog A1 (2) in say B3, what formula would I use (is the ^ on shift 6 the correct symbol?)
    You can use either

    =10^A1

    where ^ is Shift+6, or

    =POWER(10,A1)

Posting Permissions

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