Returns the exponential value, by calculating value of “e” raised to the power of the number passed to the function.
= EXP(value)
Parameters
Value |
A number whose exponential value is to be calculated. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “EXP(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= EXP(1) |
2.71828182845904 |
= EXP(“$2”) |
7.38905609893065 |
= EXP(“($2)”) |
0.135335283236613 |
= EXP(UnitPrice) |
The exponential value of the UnitPrice. |
= EXP(“abcd”) |
Displays message “EXP(abcd): Input string was not in a correct format.” |
= POWER(EXP(UnitPrice), 2) |
The square of the exponential value of UnitPrice. |
= MAX(EXP(UnitPrice), 12) |
The maximum among the ceiling value of UnitPrice and the number 12. |