In this tutorial, you will learn how to find the antilog of values in Excel.
Logarithmic functions are mostly used when working with exponents. So we often work with logarithmic functions, but we need to compute antilogarithms. The antilogarithm is simply the reciprocal of the logarithm.
If x is the logarithm of a number y in base b, then y is said to be the antilogarithm of x in base b. If logby y = x then y = antilogarithm x.
The following table shows how Excel calculates the antilogarithm of a value in base:
| Base | Number | Log | Antilog |
| x | y | =LOG(y, x) | =x^y |
| e | y | =LN(y) | =exp(y) |
| 1 | y | =LOG1(y) | =1^y |
Once you are ready, we can start by using real-life scenarios to help you understand how to find the antilog of values in Excel.
Table of Contents
Antilog of Values in Excel
Before we begin we will need a group of data to be used to find the antilog of values in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
To find the Log, we can simply use the LOG function. We can insert the following formula =LOG(B2,A2).
Step 3
To find the Antilog, we can insert the following formula =A2^C2.
Step 4
Once we are done, you will be able to find the antilog of values.
