How to Do Inverse Log in Excel (3 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.


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


How to Do Inverse Log in Excel: 3 Simple Methods

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.

do inverse log in excel


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.

Do Inverse Log in Excel with Simple Formula

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

Compute Inverse of Common Log with POWER Function

Read More: Excel Logarithmic Scale Start at 0 


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


Download Practice Workbook

Download the following workbook to practice by yourself.


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. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles


<< Go Back to Excel LOG Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo