How to Use EXP() in Google Sheets

Description

Returns Euler's number, e (~2.718) raised to a power.

How To Actually Use EXP() in Sheets

EXP(exponent)

Try EXP yourself

In cell B1, use the EXP formula to calculate e raised to the power of the value in cell A1. The result should display Euler's number raised to that power.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for EXP(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...

Advanced

IF() REGEXMATCH()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Unlock these tutorials

Learn more about the EXP() formula:

Generate a EXP() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses EXP(). 2 free AI generations, no signup. Members get unlimited use.

Generate a EXP() formula