Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 31st 06, 11:51 AM posted to microsoft.public.excel.worksheet.functions
Parag
 
Posts: n/a
Default How to Calculate ANTILOG in EXCEL SHEET?

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

Regards



  #2   Report Post  
Old March 31st 06, 11:54 AM posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How to Calculate ANTILOG in EXCEL SHEET?

Hi

Have you searched Google Groups for this? Here's one thread:
http://groups.google.com/group/micro...21c617bb046d35

Andy.

"Parag" wrote in message
...
Can you please guide me about calculation of Antilog in the excel sheet.

Regards




  #3   Report Post  
Old March 31st 06, 03:37 PM posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default How to Calculate ANTILOG in EXCEL SHEET?

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

  #4   Report Post  
Old March 31st 06, 03:38 PM posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default How to Calculate ANTILOG in EXCEL SHEET?

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 ...
Hi

Have you searched Google Groups for this? Here's one thread:
http://groups.google.com/group/micro...21c617bb046d35

Andy.

"Parag" wrote in message
...
Can you please guide me about calculation of Antilog in the excel sheet.

Regards








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 11 February 12th 06 01:38 AM
Excel - automatic information from one sheet to another?? Kathrine J Wathne Excel Discussion (Misc queries) 2 August 30th 05 09:49 AM
Copy Name and email address from web sites to excel sheet Philip Excel Discussion (Misc queries) 0 August 10th 05 11:02 AM
Updating excel sheet with selected data from another sheet in the same file gsnivas Excel Worksheet Functions 1 August 4th 05 09:55 AM
How to calculate in Excel sheet eg. add or divide any thing and i. Suku New Users to Excel 1 February 16th 05 12:53 AM


All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017