If you want to** solve an exponential equation in Excel**, you have come to the right place. Here, we will walk you through** 4 easy and suitable examples** to do the task smoothly.

**Table of Contents**hide

## Download Practice Workbook

You can download the Excel file from here and practice while reading this article.

## 4 Examples to Solve Exponential Equation in Excel

In the following dataset, you can see the **Equation for Population Growth** in cell **C4**.

Along with that, you can see the **Initial Population Po**, **Rate of Growth R**, and **Time T(years)** in cells** C5**, **C6**, and **C7** respectively. In this article, we will provide** 4 examples** to** solve an exponential equation in Excel**.

Here, we used **Microsoft Office 365** to do the task. You can use any available Excel version.

### 1. Using Generic Formula to Solve Exponential Equation in Excel

In this method, we will use a generic formula to **solve an exponential equation in Excel**.

We know, the generic formula for calculating population growth is

`P=Po*e^(R*T)`

Here,

**P = Current Population**

**Po = Initial Population **

**R = Rate of Growth**

**T = Time (years)**

Furthermore, we know that the **value of e **is** 2.718281828**.

After that, using these parameters, we will calculate the **Current Population P**.

**Steps:**

- First, we will type the following equation in cell
**C9**.

`=C5*((2.718281828)^(C6*C7))`

Here, we simply put the values of the parameters in the main equation.

- After that, press
**ENTER**.

As a result, you can see the **Current Population P** in cell **C9**.

**Read More: How to Solve 2 Equations with 2 Unknowns in Excel (2 Examples)**

### 2. Applying EXP Function

In this method, we will use **the EXP function** to calculate **Current Population P**.

**Steps:**

- First of all, we will type the following equation in cell
**C8**.

`=C5*(EXP(C6*C7))`

**Formula Breakdown**

**EXP(C6*C7)**â†’**the EXP function**returns the value of the constant**e**raised to the power of a given number.**EXP(0.45*10)**â†’ Hence, it becomes**Output: 90.0171313**

**C5*(EXP(C6*C7))**multiplies**C5**with**0171313**.**20,000*****0171313**â†’ As a result, it becomes**Output: 1800342.626****Explanation: 1800342.626**is the**Current Population P**.

- Afterward, press
**ENTER**.

Therefore, you can see the **Current Population P** in cell **C8**.

**Similar Readings**

**How to Solve Polynomial Equation in Excel (5 Simple Methods)****Solve Quadratic Equation in Excel VBA (with Quick Steps)****How to Solve Differential Equation in Excel (With Easy Steps)**

### 3. Use of LOG Function to Solve Exponential Equation in Excel

In this method, we will use **the LOG function **to** solve an exponential equation in Excel** with **different bases**.

Here, in the following picture, you can see in cell** C4 **that the equation is

**6**^{P} = 4

Afterward, let me show you how we can solve this equation and find the** Value of P** using **the LOG function**.

**6**^{P}= 4**Â log(6**^{P}) = log(4)**P log6 = log(4)****P = log(4)/log(6)**

Furthermore, we will solve the equation in Excel using **the LOG function**.

**Steps:**

- First of all, we will type the following formula in cell
**C5**.

`=LOG(4)/LOG(6)`

Here, **the LOG function** yields the logarithm of the value we specify.

- Moreover, press
**ENTER**.

Then, you can see the **Value of P** in cell **C5**.

### 4. Applying LN Function

In this method, we will use **the LN function** to **solve an exponential equation in Excel**.

**different bases**. **The LN function** is effective to solve an equation that has an **e** containing an **exponent**.

Here, in the following picture, you can see in cell** C4 **that the equation is

**200*e**^{(0.5*N)} = 345

After that, let me show you how we can solve this equation and find the** Value of P** using **the LN function**.

**200*e**^{(0.5*N)}= 345**Â e**^{(0.5*N)}= 345/200**Â ln e**^{(0.5*N)}= ln(345/200)**Â 0.5*N= ln(345/200)****N= ln(345/200)/0.5**

After that, we will solve the equation in Excel using **the LN function**.

**Steps:**

- First of all, we will type the following formula in cell
**C5**.

`=LN(345/200)/0.5`

Here, **the LN function** yields a natural logarithm of the value we specify.

** **

- In addition, press
**ENTER**.

Therefore, you can see the **Value of N** in cell **C5**.

## Practice Section

You can download the above** Excel **file to practice the explained methods.

## Conclusion

In this article, we tried to show you **4 easy examples **to **solve an exponential equation in Excel**. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website **Exceldemy** to explore more.