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 ex is 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

Function Description

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

The syntax of the function is:

EXP( number )

where the number argument is the real number that you want to raise e to the power of.


Examples

The following spreadsheet shows four different examples of the Excel Exp function.

 Formulas:
  A
1 =EXP( 100 )
2 =EXP( 0.1 )
3 =EXP( 0 )
4 =EXP( -5 )
 Results:
  A
1 2.68812E+43
2 1.105170918
3 1
4 0.006737947

For further examples of the Excel Exp function, see the Microsoft Office website.