How to Use Excel EXP Function (5 Examples)

The Excel EXP function is also known as an exponential function. It is mainly a mathematics formula that returns the value of the constant e raised to the power of a given number. Whenever data values increase or fall exponentially (at an increasingly higher rate) then the EXP function helps to calculate the rate of growth or decay.

Overview of Excel EXP Function

In this article, I will show you various examples of how you can use the Excel EXP function.


Download to Practice


Basics of EXP Function: Summary & Syntax

Summary

The EXP function calculates and returns the value of the constant e raised to the power of a given number. Here, e is a numeric constant, and the value of constant e is approximately    ≈ 2.71828.

The constant e denotes exponential growth and decay. The formula is ex.

Syntax

EXP(number)

Arguments

Arguments Required/Optional Explanation
number Required The power that e is raised to

Return Value

The EXP function returns the constant e raised to the power of a number.

Version

The EXP function is available for Excel 2000 and later versions.


5 Examples of Excel EXP Function

1. Using The EXP Function to Get e Raised to The Power of a Number

To find the value of the constant e raised to a given number, you can use the EXP function.

Here, The EXP function mathematically form is ex or e^(number).

Now, I’m going to pass the number -1 as the argument in the EXP function.

⏩ In cell D4, type the following formula to get the exponential value of the number -1.

=EXP(B4)

Using The EXP Function to Get e Raised to The Power of A Number

Here, in the EXP function, I selected the B4 cell as a number.

Then, press ENTER, and the EXP function will return an exponential value of the selected cell B4. Here, e raised to power -1.

You can follow the same process, or you can use the Fill Handle to get e raised value of the power of other values.

Using The EXP Function to Get e Raised to The Power of A Number

Here, you will get the value of e against the value 1 which is 2.718281828. It is known as the constant of e.

Read More: 51 Mostly Used Math and Trig Functions in Excel


2. Using Excel EXP Function to Get The Rate of Growth Or Decay

You can use the EXP function along with the ROUND function to calculate the growth and decay of bacteria, viruses, and microorganisms.

Let me describe the process with an example. To demonstrate the procedure, I’m going to use a dataset that contains a virus count.

I’ve taken a sample of organic solutions. The information on the solution is given below.

Using Excel EXP Function to Get The Rate of Growth Or Decay

Here, I want to calculate the count of viruses after 7 hours.

As we know, we have the formula to calculate the rate of growth or decay is

A=Pekt

The formula expressions meaning is,

A = The ending amount that we want to calculate

P = It is the initial amount provided in the solution, 250

t  = It is the time of growth or decay, 7 hours

k = It is the rate of decay or growth, 0.38

To calculate the ending amount of virus (A) after 7 hours. I going to use the described formula by using the EXP function. Which will be A = P* EXP(k*t).

⏩ In cell D9, type the following formula to get the growth of the virus in a round figure.

=ROUND(D6*(EXP(D7*D8)),0)

Using Excel EXP Function to Get The Rate of Growth Or Decay

Here, In the ROUND function, I used (D6*(EXP(D7*D8) as number and 0 as num_digits.

In the EXP function, selected both the cells D7 and D8 as numbers then multiplied it to get e raised value of the given number of both cells.

Then multiplied the exponential value with the D6 cell and passed the result to the ROUND function to get only the integer value.

Now, press ENTER, and you will get the total number of viruses after 7 hours in the solution.

Read More: How to Use ROUND Function in Excel (With 9 Examples)


3. To Calculate Rapid Growth Using The EXP Function

Several times the earth faced virus or bacteria-infected diseases with a huge number of infections. In 2019 coronavirus came with a few numbers of infected cases but within 2020 it spread all over the planet. To track the spread of such types of virus or bacterial infections we can use the EXP function.

Here, I’m going to use a sample dataset to show you how we can use the EXP function to calculate the rate of growth of such types of data values.

To Calculate Rapid Growth Using The EXP Function

To calculate how many persons have been infected at any time, I’m going to use the mathematical equation,

N = N₀eᵃᵗ

The equation expressions meaning,

N = Total number of people infected by virus

a  = Rate of infection

t   = Time (you can use day, hours, years, etc)

N0 = Initial number of infected people

⏩ In cell D9, type the following formula to get the growth of the virus.

=C6*EXP(C7*C8)

Here, In the EXP function, selected both the cells C7 and C8 as numbers then multiplied it to get e raised value of the given number of both cells.

Then multiplied the exponential value with the C6 cell to get the number of infected people after 30 days.

Now, press the ENTER key and you will get the total number of infected people after 30 days of the spread of the virus.

To Calculate Rapid Growth Using The EXP Function

If you want, you can use the ROUND function to get the round figure or only the integer number explained in Example 2.

Read More: Exponential Notation E in Excel & How to Turn Off Auto Scientific Notation!


Similar Readings


4. Using EXP Function to Calculate Unknown Variable 

To plot any 2D graphs first you will need the values of the corresponding function. In case you have any exponential function then you can use the EXP function to calculate the function with exponent.

Here, I’m going to describe an exponential equation that is y = ae.-2x. I’m going to use a dataset where I have the values of x and the slope which is denoted as a which is constant.

The formula is going to look like with the EXP function is,

y =a* EXP(-2*x)

Using EXP Function to Calculate Unknown Variable 

⏩ In cell C7, type the following formula.

=$E$4*EXP(-2*C6)

Here, In the EXP function, selected the cells C6 and multiplied it with -2 to get e raised value of the given number.

Then, multiplied the exponential value with the $E$4 cell which has the constant value of a. Here, I used absolute reference for the E4 as it is a constant value.

Now, press the ENTER key and you will get the value of Y.

Using EXP Function to Calculate Unknown Variable 

Now, by using the Fill Handle, you will get all the values of y for corresponding x.

Using EXP Function to Calculate Unknown Variable 

Read More: How to Use Excel Exponential Function of Base 10 (6 Examples)


5. To Calculate Population Growth Using EXP Function 

To calculate the latest population of any city or country you can use the EXP function.

Here, I’ve taken a dataset of a couple of countries to calculate the population rate for 10 years. Also, I took the approximate rate of growth for all countries.

To Calculate Population Growth Using EXP Function 

To calculate the population growth, I’m going to use an equation that is P = P₀*ert 

The formula expressions are,

P = Latest population

r = Rate of population growth

t = Time (years)

P0 = Initial population

⏩ In cell E4, type the following formula to get the growth of the virus.

=C8*EXP($D$4*$D$5)

Here, In the EXP function, selected the absolute reference of cells $D$4 and $D$5 because the value of D4 and D5 are constant for other countries also. Then, multiplied both values to get e raised value of the given number.

Again, multiplied the exponential value with the C8 cell to get the population of 2020.

Now, press the ENTER key and you will get the population for 10 years.

To Calculate Population Growth Using EXP Function 

As the rate of growth and time is the same for other countries so you can use the Fill Handle to get the population of 2020.

Read More: How to Calculate Exponential in Excel (3 Easy Methods)


Things to Remember

🔺 The EXP Function only takes the numeric values as an input. It shows the #VALUE error for non-numeric values.

Error of EXP Function

🔺 Always be careful while using complex exponents formulas, if you misplace any brackets, you will get incorrect output.


Practice Section

I’ve provided a practice sheet in the workbook to practice these explained examples.


Conclusion

In this article, I have shown 5 examples of the Excel EXP function. I also tried to cover the when and why the EXP function may show errors frequently. Last but not least, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.


Related Articles

Shamima

Shamima

Hello! Welcome to my Profile. I am Shamima Sultana Rita. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Computer Science and Engineering from East West University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. I love to learn new things. Data Analysis is one of my favorite fields as I love to extract patterns based on problems. Here, I'm trying to provide enriched quality content regarding Excel basics to Advanced. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo