**How To Calculate 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.

antilog_{x}Y = X^{y}

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.

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

**Template**

Further reading: how to calculate log Basic concepts Getting started with Excel Cell References