Excel EXP Function

The EXP function returns the result of the constant e raised to the nth power, where e, the base of the natural logarithm, equals 2.71828183 approximately.

Syntax

=EXP (number)

Arguments

Return value

The EXP function returns a numeric value.

Function notes

1. Number, the only argument in the EXP function, should be supplied as a numeric value.
2. EXP function will return the #VALUE! error if number is non-numeric.
3. The number e is an irrational number, which is mathematically constant and approximately equal to 2.71828183.
4. Set the number to 1, the value of the constant e will be returned.
5. EXP is the inverse of LN, the natural logarithm of number.

Examples

Supposing, you want to get the values of the constant e raised to the power of given numbers in the table below. Please do as follows.

1. Copy the formula below into cell C4.

=EXP (B4)

2. Then drag the fill handle down to the cells you want to apply this formula too. The results are as the following screenshot shows.

Note:

1. We can directly input value in the number argument in the formula. For example, the formula in cell C4 can be changed to:

   =EXP (0)

Relative Functions:

• Excel PI Function
  The PI function returns the number 3.14159265358979 of the mathematical constant called pi.

• Excel POWER Function
  The POWER function returns the result of a number raised to a given power.