How to Solve Exponential Equation in Excel (4 Suitable Examples)

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.

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.

How to Solve Exponential Equation in Excel


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

Applying exp function in Excel

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.

applying exp function in excel


Similar Readings


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

6P = 4

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

  • 6P = 4
  •  log(6P) = 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.

Applying LN function in excel

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

Practice problem on solving exponential equation in Excel


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.


Related Articles

Afia Kona

Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo