# 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: 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.