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

## 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 **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 (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 **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 (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.