How to use EXP Google Sheets formula?

The syntax for the EXP formula is =EXP(exponent), it has 1 required parameter.

EXP

The EXP function returns the result of e raised to the power of a given exponent. This function is commonly used in mathematical and scientific calculations.

How to use EXP formula?
Examples of using EXP formula
EXP formula not working?
Similar formulas to EXP

Usage

Use the EXP formula with the syntax shown below, it has 1 required parameter:

=EXP(exponent)

Parameters:

exponent (required):
The exponent to which e is raised. Must be a valid number.

Examples

Here are a few example use cases that explain how to use the EXP formula in Google Sheets.

Calculating compound interest

The EXP function can be used to calculate the compound interest on a loan or investment over time.

Modeling population growth

The EXP function can be used to model the growth of a population over time, given a known rate of increase.

Calculating decay

The EXP function can be used to model the decay of a radioactive substance or the depreciation of an asset over time.

Common Mistakes

EXP not working? Here are some common mistakes people make when using the EXP Google Sheets Formula:

Incorrect argument type

One common mistake is providing an argument that is not a number or a cell reference to a number.

Forgetting to close parentheses

Another common mistake is forgetting to close the parentheses after the exponent argument.

Using incorrect syntax

Some users may accidentally use a different syntax than the one provided, resulting in an error.

The following functions are similar to EXP or are often used with it in a formula:

LN
The LN formula returns the natural logarithm of a given value. The natural logarithm is the logarithm to the base e, where e is an irrational number approximately equal to 2.71828. The formula is commonly used in mathematical and scientific calculations.
POW
The POW formula is a mathematical operator in Google Sheets used to raise a base number to the power of an exponent. It returns the result of the calculation. This formula is commonly used in financial analysis, engineering, and scientific research.
SQRT
The SQRT function returns the positive square root of a given number. It can be used to find the length of a side of a right triangle, or to calculate standard deviation. The function takes one argument, the value or reference to the cell containing the number for which you want to find the square root.

Learn More

You can learn more about the EXP Google Sheets function on Google Support.

EXP