How to Calculate ANTILOG in EXCEL SHEET?

J

Jerry W. Lewis

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

=EXP(LN(x))
=10^LOG10(x)
=b^LOG(x,b)

Jerry
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top