Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to Calculate ANTILOG in EXCEL SHEET?
9,784 views
Skip to first unread message
Parag
Mar 31, 2006, 5:51:02 AM3/31/06
to
Can you please guide me about calculation of Antilog in the excel sheet.
Regards
Andy
Mar 31, 2006, 5:54:13 AM3/31/06
to
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" <Pa...@discussions.microsoft.com> wrote in message
news:14417233-8C5D-456A...@microsoft.com...
Jerry W. Lewis
Mar 31, 2006, 9:37:01 AM3/31/06
to
Log base what? All of the following are antilogs that return x
=EXP(LN(x))
=10^LOG10(x)
=b^LOG(x,b)
Jerry
Bernard Liengme
Mar 31, 2006, 9:38:02 AM3/31/06
to
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
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:OcRsBFLV...@TK2MSFTNGP14.phx.gbl...
0 new messages