spot_img

How To Calculate Antilog In Excel?

In this Excel tutorial you will teach yourself how to handle antilog in Excel.

What is antilog?

Sometimes to show is better than to describe. 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 types 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 antilog of 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 result of log10

Logarithm

=log(x,base)=y

=base^y=x

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

To get antilog og logarithm to need to power base to the result.

 

Excel antilog

 

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

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell