Table of Contents
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
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.