EXP
TheEXP
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:
 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 theEXP
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.
Related Formulas
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.