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)
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.
