Tags: antilog, calculate, calculation, excel, guide, microsoft, msdn, sheet, software

How to Calculate ANTILOG in EXCEL SHEET?

On Microsoft » Microsoft Excel

2,257 words with 3 Comments; publish: Wed, 04 Jun 2008 15:39:00 GMT; (30630.27, « »)

Can you please guide me about calculation of Antilog in the excel sheet.

Regards

All Comments

Leave a comment...

  • 3 Comments
    • Log base what? All of the following are antilogs that return x

      =EXP(LN(x))

      =10^LOG10(x)

      =b^LOG(x,b)

      Jerry

      "Parag" wrote:

      > Can you please guide me about calculation of Antilog in the excel sheet.

      > Regards

      #2; Wed, 04 Jun 2008 15:41:00 GMT
    • Definition of LOG: if x = 10^y, then y is said to be the log(base 10) of x

      It is the number that 10 must be raised to to generate x

      So if you know the log of a number (you know y), then you can find x using x

      = 10^y

      In Excel =10^A1

      If you want natural logs replace 10 by e (exp(1))

      Natural antilog =EXP(A1)

      best wishes

      --

      Bernard V Liengme

      www.stfx.ca/people/bliengme

      remove caps from email

      <Andy> wrote in message news:OcRsBFLVGHA.5288.excel.todaysummary.com.TK2MSFTNGP14.phx.gbl...

      > Hi

      > Have you searched Google Groups for this? Here's one thread:

      > http://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/a02e41e483dd7f4a/4221c617bb046d35?q=antilog&rnum=1#4221c617bb046d35

      > Andy.

      > "Parag" <Parag.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:14417233-8C5D-456A-B302-67E5E2872251.excel.todaysummary.com.microsoft.com...

      >> Can you please guide me about calculation of Antilog in the excel sheet.

      >> Regards

      >>

      >

      #3; Wed, 04 Jun 2008 15:42:00 GMT