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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Solve Exponential Equation in Excel: 4 Suitable Examples

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.


2. Applying EXP Function

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

Steps:

  • First, 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


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, 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. The LN function is effective in solving 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, 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


Download Practice Workbook

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


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.


Related Articles

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo