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