Excel Functions Tutorials

- Excel Formulas Cheatsheet
- Excel
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Concatenate Excel Function
- RIGHT Function in Excel
- LEN in Excel
- LEFT Function in Excel
- Search Function in Excel
- TEXT Function in Excel
- PROPER in Excel
- MID in Excel
- Trim in Excel
- CLEAN Excel Function
- EXACT Excel Function
- REPT Function in Excel
- CODE Excel Function
- FIND Function in Excel
- VALUE Function in Excel
- Char Function In Excel
- Substitute Function in Excel
- Substring in Excel

- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- TRANSPOSE Excel Function
- Row Function in Excel
- OFFSET Excel Function
- VLOOKUP with Multiple Criteria
- IFERROR with VLOOKUP in Excel
- Fixing VLOOKUP Errors
- Alternatives to Vlookup

- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- DSUM
- COMBIN Excel Function
- INT Excel Function (Integer)
- TANH in Excel

- Date and Time Function in Excel
- Statistical Function in Excel
- AVERAGE Excel Function
- CORREL Excel Function
- COUNT Excel Function
- COUNTIF Excel Function
- FREQUENCY Excel Function
- MAX Excel Function
- MEDIAN Excel Function
- GROWTH Excel Function
- SLOPE Function in Excel
- TREND Function in Excel
- SMALL Function in Excel
- MODE Excel Function
- LARGE Excel Function
- PERCENTILE Excel Function
- LINEST Excel Function
- T-TEST in Excel
- QUARTILE Excel Function
- FORECAST Excel Function
- MIN in Excel
- Standard Deviation in Excel
- COUNTIF with Multiple Criteria
- Mean vs Median
- NORM.S.INV Function in Excel
- NORMDIST in Excel
- Variance vs Standard Deviation

- Information Functions in Excel
- Excel Charts
- Column Chart in excel
- Stacked Column Chart
- Pie Chart in Excel
- Area Chart in Excel
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Histogram Excel Chart
- Waterfall Chart in Excel
- Pareto Chart in Excel
- Bubble Chart in Excel
- Gantt Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Dynamic Chart in Excel

- Excel Tools
- Watch Window in Excel
- List Box in Excel VBA
- Conditional Formatting in Excel
- Data Table in Excel
- Data Validation Excel
- Paste Special in Excel (With Top 10 Shortcuts)
- One Variable Data Table in Excel
- Two-Variable Data Table in Excel
- Scenario Manager in Excel
- Solver in Excel
- Name Range in Excel
- Dynamic Named Range in Excel
- Sort Data in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Auto Format Excel
- Track Changes in Excel
- Text to Columns in Excel
- Merge Cells in Excel
- Lock Cells in Excel
- Scroll Bars in Excel
- Spell Check in Excel
- Filters in Excel
- Auto Filter In Excel
- Advanced Filter in Excel
- Recording Macros in Excel
- Add-Ins in excel
- Excel Fill Handle
- AutoFill in Excel
- Excel Tables
- Radio Button in Excel
- Combo Box in Excel and VBA
- Checkbox in Excel

- Excel Tips
- How to Unhide Columns in Excel?
- Convert Date to Text in Excel
- Top 20 Keyboard Shortcuts in Excel
- Convert Numbers to Text in Excel
- Show Formula in Excel
- Absolute Reference in Excel
- Relative References in Excel
- Superscript in Excel
- Subscript in Excel
- Formula Errors in Excel
- Convert Text to Numbers in Excel
- Insert Multiple Rows in Excel
- Remove Blank Rows in Excel
- Highlight Every Other Row in Excel
- External Links in Excel
- Insert Hyperlinks in Excel
- Remove Hyperlinks in Excel
- Combine Cells in Excel
- Remove Duplicates in Excel
- Random Numbers in Excel
- Drop Down List in Excel
- Refresh Pivot Table in Excel
- Column Sort in Excel
- Hiding a Column in Excel
- Count Unique Values in Excel
- CAGR Formula in Excel
- Equations in Excel
- How to Delete Pivot Table?
- Excel Subtraction Formula
- Excel Extensions
- Hide Formula in Excel
- Numbering in Excel
- Auto Numbering in Excel
- Row Limit in Excel
- Delete Row Shortcut in Excel
- Arrays in Excel VBA
- Array Formulas in Excel
- Dynamic Tables in Excel
- Convert Columns to Rows in Excel
- Formatting in Excel
- Print Comments in Excel
- Excel vs Google Sheets

**Exponential in Excel (Table of Contents)**

- Exponential Function in Excel
- Exponential Formula
- What is e in Mathematics?
- How to Use EXP Function in Excel? (with Examples)

## Exponential Function in Excel

Excel has an exponential excel function called EXP function which is categorized as Math/Trig Function that returns a numeric value which is equal to **e **raised to the power of a given number.

### Exponential Excel Formula

* Exp function in Excel takes only one input which is required, it is the exponent value raised to base e.*

### What is e in Mathematics?

The number e is an irrational number, whose value is constant and is approximately equal to 2.7182. This is number is also known as *Euler’s Number**.* The value of the number is calculated by the formula

**How to Use EXP Function in Excel? (with Examples)**

Like LOG function is used when the rate of change in the data increases or decreases quickly, the EXP function in Excel is used when data values rise or fall at increasingly higher rates.

In Excel, while working non-linear trend lines (set of points on an exponential excel function’s graph) or non-linear graphs EXP function in Excel is widely used.

An Exponential function in Excel is also used to calculate the growth and decay of a bacteria and microorganisms.

### Exponential in Excel Example #1

Suppose we have a sample for organic solutions, the lab examiner at time t=0 hours puts one hundred bacteria into the solution in order to determine the suitable growth medium. After 5 hours, the examiner needs to calculate the count of bacteria. The growth rate of the bacteria in the given organic solution is 0.25/hour

For the rate of growth or decay, we have a formula

*A=Pe*^{kt}

- Where A is the ending amount
- P is the initial amount
- t is the time of growth or decay
- k is the rate of decay or growth

In this case, A= 500, t = 5 hours, k = 0.25, P=?

So in order to calculate the value of k in Excel, we have to use the exponential in excel and log function

P = A/e^{kt}

Therefore, P = A/EXP(k*t)

In Excel, the formula will be

**=ROUND(D3+D3/(EXP(G3*F3)),0)**

After 5 hours, the total number of bacteria in the given organic solution will be near around 129 in a count.

### Exponential in Excel Example #2

We have a function *f(x) *that is an exponential function in excel given as *y = ae ^{-2x} *where ‘a’ is a constant and for the given value of x we need to find the values of y and plot the 2D exponential functions graph.

The value of a is 0.05

To compute the value of y we will use the EXP function in excel so the exponential formula will be

=**a* EXP(-2*x)**

Applying the exponential formula with the relative reference we have

**=$B$5*EXP(-2*B2**

Applying the same exponential formula to other cells, we have

Plotting the exponential functions graph on the x-y axis we have the following graph for the above-given function and values

### Exponential in Excel Example #3

Suppose we have the population data of 5 different cities given for the year 2001, and the rate of growth of the population in the given cities for 15 years was approximately 0.65%. We need to calculate the latest population of the given cities after 15 years.

For the rate of growth, we have the formula,

**P = P _{0}*e^{rt}**

Where **P** is the latest population (which we will calculate in this case)

**P _{0}** is the initial population

**r** is the rate of growth

**t** is the time

Here, in this case, we have to calculate P for five different cities with the given rate of growth of 0.65

So in order to calculate the rate of growth of the population we will use the above population growth formula

In Excel to calculate the Exponential power we will further use the Exponential Function in Excel, so the exponential formula will be

**=B2*EXP($F$1*$F$2)**

Applying the same exponential formula in reference to other cities we have

**Output:**

The Exponential Function in Excel is also used for also calculating the probability distribution in the statistics also known as the exponential probability distribution. The exponential distribution deals with the amount of time for a specific event to occur.

The Exponential function in Excel is also used in the regressions linear modeling in the statistics.

**Things to Remember About Exponential Function (EXP) in Excel**

The Exponential function in Excel is often used with the Log function, for example, in case, if we want to find the rate of growth or decay, in that case, we will use the EXP and the LOG function together.

We can also use the POWER function in place of the Exponential function in Excel but the only difference is the measurement precision. While using the POWER function we can provide the of e as 2.71 or may be up to 3-4 decimal places, however, the EXP function in excel, in general, takes the value of e to 9 decimal places.

So, if are calculating an Exponential in excel Series, of dealing with non-linear exponential functions graph in which we have the Exponential value, it is better to use the EXP function in excel instead of the POWER function.

EXP function in excel always takes the numeric value as an input, if we provide any other input other than the numeric value it generates #NAME? Error.

While dealing with the complex Exponents, for example, =EXP(-(2.2/9.58)^2), one should be careful with the brackets, if we mess up with the brackets the output may differ from the actual output, so it should be =EXP(-((2,2/9,58)^2))

You can download this Exponential in Excel template here – Exponential Function Excel Template

### Recommended Articles

This has been a guide to Exponential Function in Excel. Here we discuss the Exponential Formula and how to use EXP in Excel along with Exponential Function examples and downloadable excel templates. You may also look at these useful functions in excel –

- SUMIF
- MID in Excel
- How to Concatenate in Excel?
- How to Search in Excel?

## Leave a Reply