How to Find the Antilog of Values in Excel


The antilog of a number is the inverse of the log of a number.

So, if you calculate the log of a number you can then use the antilog to get back the original number.

For example, suppose we start with the number 7. If we take the log (base 10) of 7 then we would get .845:

log10(7) = .845

The antilog (base 10) of the value 0.845 can be found by taking 10 raised to the power of 0.845:

10.845 = 7

The antilog allowed us to get back the original number.

The following table shows how to calculate the antilog of values in Excel according to their base:

Base Number Log Antilog
x y =LOG(y, x) =x^y
e y =LN(y) =exp(y)
10 y =LOG10(y) =10^y

The following examples show how to calculate the antilog of values in Excel using different values for the base.

Example 1: Calculating the Antilog of Base 10

The following screenshot shows how to calculate the log base 10 of a list of values in Excel:

To obtain the antilog of the values in column B, we simply need to use the formula =10^value in column C:

Antilog in Excel for log base 10

By taking the antilog of the values in column B, we were able to obtain all of the original values.

Example 2: Calculating the Antilog of a Natural Log

The following screenshot shows how to calculate the natural log of a list of values in Excel:

To obtain the antilog of the values in column B, we can use the formula =exp(value) in column C:

Antilog in Excel for natural logarithm

By taking the antilog of the values in column B, we were able to obtain all of the original values.

Example 3: Calculating the Antilog of Base x

The following screenshot shows how to calculate the log base 7 of a list of values in Excel:

To obtain the antilog of the values in column B, we can use the formula =7^value in column C:

By taking the antilog of the values in column B, we were able to obtain all of the original values.

Additional Resources

How to Transform Data in Excel (Log, Square Root, Cube Root)
How to Create a Log-Log Plot in Excel
How to Create a Semi-Log Graph in Excel

Leave a Reply

Your email address will not be published.