The Excel EXP function is a Math formula that returns the value of the constant e (Euler’s number) raised to the power of a given number (ex). The constant e is approximately equal to 2.71828, which is the base of the natural logarithm. In this guide, we’re going to show you how to use the EXP function and also go over some tips and error handling methods.


Supported versions

  • All Excel versions

Excel EXP Function Syntax

EXP(number)


Arguments

number

The power that e is raised to.


Example

The EXP function calculates the value of the constant e raised to a given number. The formula is simply ex. The following function returns the base of the natural logarithm e raised to the power of 3.

=EXP(3)

Download Workbook


Tips

  • Set the number argument to 1 to get the value of the constant e.
  • The constant e is called the Euler’s number, named after the Swiss mathematician Leonhard Euler.
  • EXP is the inverse of LN, the natural logarithm of a number.