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