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

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.

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

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.

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

Advanced Excel Exercises with Solutions PDF