This guide will help you find the antilog of a particular value in Excel.
Antilogs or inverse logarithms is an operation in mathematics that is found by raising a logarithm to its base.
To understand antilogs, we must first take a look at how a logarithm is derived.
A logarithm refers to the mathematical operation that determines how many times a number must be multiplied by itself to equal another number.
The logarithm operation always includes a base and an argument. The base refers to the number to be multiplied by itself to equal the argument.
For example, the logarithm log416 asks for the number of times the base 4 must be multiplied by itself to equal 16. In this case, log416 = 2.
An antilogarithm or antilog is the inverse logarithm function. To calculate the antilog of a number y, we must raise the base b to the power of y.
Using the previous example, if we want to get the antilog of 2 given a base of 4, we will arrive at the following answer:
x = log4-1(2) = 42 = 16
In this guide, we will look into how to find the antilog of any number given a base of 10. We will expand our formula to work with any arbitrary base. Lastly, we will look into how to get the antilog using the natural logarithm.
Now that we have a grasp on when to use the antilog operation, let’s learn how to use it and work on an actual sample spreadsheet.
A Real Example of Finding the Antilog of Values in Excel
The following section provides several examples of how to find the antilog in Excel. We will also go into detail about the formulas and tools used in these examples.
First, let’s take a look at computing the antilog for values using log base 10.
The table below shows a list of x values and their corresponding logarithms in base 10. We want to output the antilog of the values found in column C.
To get the antilog, we just need to use the following formula:
We must multiply our base by the argument of our antilog.
Since we are calculating the inverse of the logarithm function, we are just undoing the logarithm and returning the original value x.
We can expand on this principle by modifying our formula to accept any arbitrary base.
To get the values in Column E, we’ll use the following formula:
We will again multiply the indicated base by the argument of the antilog function.
Next, we will tackle the case where we used the natural logarithm.
Since the natural logarithm uses the base equal to the constant e, we will have to use that number for our antilog formula.
We can use the
EXP function as a simpler way to multiply e to a specific power:
Do you want to take a closer look at our examples? You can make your own copy of the spreadsheet above using the link attached below.
Use our sample spreadsheet to test out how we modified each of our antilog formulas to handle different logarithm bases.
If you’re ready to try using the antilog, head over to the next section to read our step-by-step breakdown on how to do it!
How to Find the Antilog of Values in Excel
This section will guide you in finding the antilog of a given set of values in Excel. We will be using the exponent operator ‘^’ and the
EXP function to handle exponentiation.
- First, select the cell you want to output the antilog. In this example, we’ll choose cell D6.
- We can compute for the antilog of logarithms that use base 10 by raising 10 to the given argument.
- Hit the Enter key to evaluate the function.
- Use the Fill Handle tool to find the antilog of the rest of the given values.
- Next, we’ll use another formula to find the antilog of logarithms of arbitrary bases. Instead of using 10 as the base, we’ll use a cell reference to the n field in our table.
- We’ll use the Fill Handle tool to find the antilog of the rest of the table.
- In this table, we want to calculate the antilog of a natural logarithm. Select the cell you want to output the antilog.
- Next, use the
EXPfunction to raise the constant e to a specified value.
- Use the Fill Handle tool to find the antilog of all natural logarithms provided.
These are all the steps needed to perform the antilog operation in Excel.
This step-by-step guide should provide you with all the information you need to start finding the antilog of a logarithm result.
Logarithms and antilogs are just some examples of the many mathematical functions you can use in your spreadsheets. Our website offers hundreds of other functions and methods to help you get more out of Microsoft Excel.
With so many other Excel functions available, you can find one appropriate for your use case.
Don’t miss out on our team’s new spreadsheet tips, tricks, and best practices. Subscribe to our newsletter to stay updated on the latest guides from us!