# How to Estimate Inverse Exponential in Excel: 3 Ideal Examples

### Method 1 – Estimating Inverse of ex

Steps:

• Select cell C9.
• Write down the following formula in the cell.

`=LN(B9)`

• Press Enter.

• Drag the Fill Handle icon up to cell C13.

• Get the inverse function for our desired x value.

Say that our formula works perfectly and 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. We are showing the step-by-step mathematical derivation below:

### Method 2 – Calculation of Inverse of e3x+5

Steps:

• Select cell C9.
• Write down the following formula in the cell.

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

• Press Enter.

• Drag the Fill Handle icon up to cell C13.

• Figure out the value of the inverse function.

Say that our formula works effectively, and we can 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? We are showing the step-by-step mathematical formula derivation below:

### Method 3 – Determining the Inverse of 22x+3

Steps:

• Select cell C9.
• Write down the following formula in the cell.

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

• Press Enter.

• Drag the Fill Handle icon up to cell C13.

• You will be able to get the result.

Inverse Function of Our Exponential

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

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF