How to calculate antilog in Excel?

In this Excel tutorial, you will learn how to handle antilog in Excel.

What is antilog?

Sometimes, showing is better than describing. Here is the equation which will show you what is antilog.

antilogxY = Xy

I hope you understand now.

 

How to calculate antilog in Excel?

There are different types of logarithms in Excel. To calculate antilog, you need to calculate the opposite of the logarithm calculations.

 

Natural logarithm

ln(x)=y

Antilog of natural logarithm

=exp(y)=x

Antilog ln formula is =EXP(B2) in my example.

So to calculate the antilog of a natural logarithm, you need to calculate the power of the number.

 

Log base 10

=log10(x)=y

Antilog of log 10

=10^y=x

Antilog log10 formula is =10^B5 in my example.

To calculate the inverse of log base 10 you need to power 10 to the base of the result of log10.

 

Logarithm

=log(x,base)=y

=base^y=x

Antilog log formula is =B9^B5 in my example.

To get the antilog of a logarithm, you need to power base the result.

 

Excel antilog

As you can see, in every example, calculations work because antilog is equal to the number.

Here's the link to the antilog spreadsheet, which will help you understand.

Further reading:
How to calculate log
How to calculate exponent