Results 1 to 5 of 5

Antilog

This is a discussion on Antilog within the Excel Questions forums, part of the Question Forums category; How do you do, or use antilog in excel. The log function is Ok....

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Sydney - Australia
    Posts
    7

    Default

    How do you do, or use antilog in excel. The log function is Ok.

  2. #2
    dk
    dk is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,932

    Default

    As far as I know, Excel has no AntiLog function. However, it's just a simple calculation:-

    Assuming base 10, the antilog of x is 10^x

    e.g.

    LOG10(100)=2

    Antilog 2= 10^2 = 100

    Does that make sense?
    _________________
    Hope this helps,
    DK


    [ This Message was edited by: dk on 2003-02-19 20:50 ]

  3. #3
    New Member
    Join Date
    Aug 2009
    Posts
    7

    Default Re: Antilog

    - but how do you make excel calculate the antilog of a number in a cell? A calculated number? What is the syntax? The caret does not seem to work?

    - Sorry - it does! =10^(-(19,9+J4)/3,48) (with J4 =23,4) returns 3,56224789026243E-13 - which at least is the right order of magnitude...

    Last edited by bmwill; Oct 16th, 2009 at 03:15 PM. Reason: Additional information

  4. #4
    VoG
    VoG is online now
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,477

    Default Re: Antilog

    Try

    =10^A1
    HTH, Peter
    Please test any code on a copy of your workbook.

  5. #5
    New Member
    Join Date
    Aug 2009
    Posts
    7

    Default Re: Antilog

    Thanks Peter
    - fast response even if I did figure out to do it proper myself!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com