Aung Shine
Sometimes, we have to carry out mathematical operations in our Excel worksheet. Dealing with such operations can include Exponential Values of some data and Logarithmic Functions. When working with Log functions, it’s practical that we will also need to find the Inverse Log at some point. If you are familiar with Excel, you’ll know that we can get the Log of a number quite easily with the Excel LOG function. But, there’s no such function available to get the Inverse Log value. Therefore, we’ll show you the simple methods to Do Inverse Log in Excel in this article.
Download Practice Workbook
Download the following workbook to practice by yourself.
Introduction to Log and Inverse Log
Suppose, we have a number 1000 (Result). Let’s say we have another number, 10, which we’ll name Base. Now, the Log of a number (Result) represents the number of times a factor (Base) gets repeatedly multiplied to get the number (Result). In this instance, we have to do 10 x 10 x 10 i.e. 3 times, to get the Result (1000). Therefore, the Log of 1000 is 3. It’s written as Log101000 = 3. The base is 10. And here, the Inverse Log is 1000 to the Base 10. So, the Inverse log (Result) is simply the output of a Base value raised to a Power (Log).
3 Simple Methods to Do Inverse Log in Excel
To illustrate, we’ll use a sample dataset as an example. For instance, in the following dataset, we have a Base in column B, and Log values in column C. Now, we have to find the Inverse Log of these numbers in column D. For that purpose, carefully learn the below methods.
1. Do Inverse Log in Excel with Simple Formula
In our first method, we’ll apply a simple formula. As we have already mentioned that the Inverse Log (Result) is simply the output of a Base value raised to a Power (Log), we’ll use this fact in creating the formula. Therefore, follow the steps below to perform the task.
STEPS:
- First, select cell D5. Here, type the formula:
=B5^C5- Then, press Enter.
- After that, use the AutoFill tool to complete the series.
- Thus, you’ll get to see the expected Inverse Log values.
Read More: How to Calculate Logarithmic Growth in Excel (2 Easy Methods)
2. Compute Inverse of Common Log with POWER Function
So far, we have discussed the Log and Inverse Log. In this method, we’ll present the Common Log. In Common Log, the Base is always 10. It’s denoted by Log10(a) (a=any number/result). Whenever the Base is not specified in the Logarithmic Functions, you’ll know that it’s a Common Log. We can also write Log(a) without mentioning the Base 10. So, it’s pretty easy to find the Inverse of a Common Log. We’ll use the POWER function for this case. This function gives a result after we specify a Base and a Power in the function argument. Hence, follow the below process.
STEPS:
- First of all, in cell D5, insert the formula:
=POWER(B5,C5)- Afterward, press Enter and the result will emerge.
- Consequently, fill the series using the AutoFill tool.
- As a result, you’ll get all the results.
Read More: Excel Logarithmic Scale Start at 0 (A Detailed Analysis)
3. Get Inverse of Natural Log in Excel
Moreover, we have another Log known as Natural Log. It’s a special type of logarithm. In Natural Logarithm, the Base is always e. It’s written as Loge(a) (a=any number/result). We can also use Ln(a) instead. Here, e is a mathematical constant and the value is approximately 2.718281828459. It’s also widely known as Euler’s Number. We have a built-in function, the EXP function, which can find the Inverse of Natural Log in Excel. The EXP function returns the output when e is raised to the power of a number. Now, learn the following process for Doing Inverse Log in Excel.
STEPS:
- Select cell D5 at first.
- Then, type the formula:
=EXP(C5)- Press Enter.
- At last, apply AutoFill for getting the Inverse Log of the rest.
Read More: How to Calculate Antilog in Excel (With 3 Examples)
Conclusion
Henceforth, you will be able to Do Inverse Log in Excel following the above-described methods. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.
