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.

**Table of Contents**Expand

## 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 **Log _{10}1000 = 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.

### 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. 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 **Log _{10}(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Â **

### 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 **Log _{e}(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

**How to Calculate Log in Excel****How to Calculate Log Base 2 in ExcelÂ****How to Calculate Natural Logarithm in ExcelÂ****How to Take Log of Negative Numbers in Excel****How to Log Transform Data in ExcelÂ****How to Plot Log Scale in Excel****How to Plot Log Log Graph in ExcelÂ**

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