# How to Estimate Inverse Exponential in Excel (3 Ideal Examples)

Get FREE Advanced Excel Exercises with Solutions!

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 ex

In the first example, we will estimate the inverse of the ex 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 ex function. To soothe your curiosity, we are showing the step-by-step mathematical derivation below:

### 2. Calculation of Inverse of e3x+5

In this example, we are going to calculate the inverse of the e3x+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 e3x+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 22x+3

In the last example, we are going to determine the inverse of the 22x+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

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

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF