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:

log_{10}(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:

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:

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