Quick Answer
EXP Function
Returns e raised to a power.
✓ Excel✓ Google SheetsExcel All versions
Syntax
EXP
(number)
Parameters
| Parameter | Description | Required |
|---|---|---|
| number | The exponent to which e is raised. | Required |
Basic Example
e raised to the power of 1
=EXP(1)Result2.718281828
e¹ equals the constant e, about 2.71828.
Advanced Examples
Example 1: e squared
Compound growth base.Raise e to 2.
=EXP(2)Result: 7.389056099
e² ≈ 7.38906.
Example 2: Inverse relationship with LN
Verify the log identity.LN and EXP cancel each other.
=LN(EXP(3))Result: 3
Taking the natural log of e³ returns 3.
How EXP Works
EXP computes e^number, where e ≈ 2.71828182845904. It is the inverse of LN: LN(EXP(x)) = x and EXP(LN(x)) = x (for x > 0).
1
Select the cell
Click the cell for the result.
2
Enter the formula
Type =EXP(number).
3
Press Enter
The value of e^number appears.
Important Notes & Limitations
Very large exponents overflow to #NUM! (e.g. EXP(710) and above).
Results are floating-point approximations of e.
EXP only computes powers of e; use POWER for other bases.
Common Errors & Fixes
#NUM!The exponent is too large, causing overflow.Fix: Use a smaller exponent or scale the calculation.
#VALUE!Non-numeric argument.Fix: Supply a numeric exponent.
Download Practice File
EXP
expPractice EXP with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the EXP function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Frequently Asked Questions
What is e?
e is Euler's number, approximately 2.71828182845904, the base of natural logarithms.
How do I raise other numbers to a power?
Use POWER(base, exponent) or the ^ operator; EXP only raises e.
Why does EXP(LN(x)) equal x?
EXP and LN are inverse functions, so they cancel each other for positive x.