Estimating the inverse of an exponential function is a pretty common task for students and people who work with mathematical equations. Using Microsoft Excel, we can easily calculate the value of inverse exponential. In this article, we are going to demonstrate to you 3 ideal examples to evaluate inverse exponential in Excel. If you are also curious about it, download our practice workbook and follow us.

## Estimate Inverse Exponential in Excel: 3 Ideal Examples

To demonstrate the examples, we consider three different types of exponential functions. First, we will show you the mathematical expression of an inverse function manually, and then using our Excel tool, we are going to estimate the value for each case.

**📚 Note:**

All the operations of this article are accomplished by using the Microsoft Office 365 application.

### 1. Estimating Inverse of e^{x}

In the first example, we will estimate the inverse of the **e ^{x}** function with the help of the

**LN**function. Our exponential function and its inverse function equation are in the range of cells

**C5:C6**. We consider some value of

**x**in the range of cell

**B9:B13**and the result will be in the range of cell

**C9:C13**.

The steps to get the value of this inverse function is given below:

**📌 Steps: **

- First of all, select cell
**C9**. - Now, write down the following formula in the cell.

`=LN(B9)`

- Then, press
**Enter**.

- After that, drag the
**Fill Handle**icon up to cell**C13**.

- You will get the inverse function for our desired
**x**value.

Thus, we can say that our formula works perfectly, and we are able to estimate the inverse value of our exponential function in Excel.

**Inverse Function of Our Exponential**

You may be curious to know how we know the inverse of the **e ^{x}** function. To soothe your curiosity, we are showing the step-by-step mathematical derivation below:

### 2. Calculation of Inverse of e^{3x+5}

In this example, we are going to calculate the inverse of the **e ^{3x+5}** function using the

**LN**function. The mathematical expression of our exponential function and its inverse function equation is in the range of cells

**C5:C6**. Here, we took some value of

**x**in the range of cell

**B9:B13**and the result will be in the range of cell

**C9:C13**.

The steps to get the value of this inverse function is shown as follows:

**📌 Steps: **

- At first, select cell
**C9**. - After that, write down the following formula in the cell.

`=(LN(B9)-5)/3`

- Press
**Enter**.

- Now,
**drag**the**Fill Handle**icon up to cell**C13**.

- You will figure out the value of the inverse function.

Hence, we can say that our formula works effectively, and we are able to calculate the inverse value in Excel.

**Inverse Function of Our Exponential**

A question may arise in your mind how do we know the expression of the inverse function of **e ^{3x+5}**? To soothe your curiosity, we are showing the step-by-step mathematical formula derivation below:

**Read More:** How to Type Exponential in Excel

### 3. Determining Inverse of 2^{2x}+3

In the last example, we are going to determine the inverse of the **2 ^{2x}+3** function with the help of the

**LOG**function. The exponential function and its inverse function equation are in the range of cells

**C5:C6**. We have some value of x in the range of cell

**B9:B13**and we will display the result in the range of cell

**C9:C13**.

The procedure is explained below step-by-step:

**📌 Steps: **

- First of all, select cell
**C9**. - Afterward, write down the following formula in the cell.

`=LOG((B9-3),2)`

- Now, press
**Enter**.

- Next,
**drag**the**Fill Handle**icon up to cell**C13**.

- You will be able to get the result.

Finally, we can say that our formula works successfully, and we are able to determine the inverse value of our exponential function in Excel.

**Inverse Function of Our Exponential**

Here, we are going to show you the step-by-step procedure to get the mathematical equation of our inverse function:

**Read More: **How to Calculate Exponential in Excel

**Download Practice Workbook**

Download this practice workbook for practice while you are reading this article.

## Conclusion

Thatâ€™s the end of this article. I hope that this article will be helpful for you and you will be able to estimate the inverse exponential of a function in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

## Related Articles

- How to Display Exponents in Excel
- How to Use Exponent Symbol in Excel

- How to Use Excel Exponential Function of Base 10
- Convert Scientific Notation to x10 to the Power of 3 in Excel

- How to Make Exponent in Excel Text
- How to Use Negative Exponents in Excel

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