The Excel EXP Function

Related Functions:
LN Function
Exponential Function

The mathematical constant, e, is the constant value (approx. equal to 2.71828182845904), for which the derivative of the function exis equal to e.

The Exponential Function (written exp(x)) is therefore the function ex.

The Exponential Function is shown in the chart below :

Chart Showing the Exponential Function

Basic Description

The Excel EXP function calculates the value of the mathematical constant e, raised to the power of a given number.

The format of the function is :

EXP( number )

where the number argument is a positive or negative real number that you want to raise e to the power of.


Examples

The spreadsheets below show four different examples of the Excel Exp function.

The functions are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
 A
1=EXP( 100 )
2=EXP( 0.1 )
3=EXP( 0 )
4=EXP( -5 )
 Results:
 A
12.68812E+43
21.105170918
31
40.006737947

Further examples of the Excel Exp function can be found on the Microsoft Office website.