POW Function
Returns a number raised to the power of an exponent.
Syntax
POW(number, exponent)
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
number |
Required |
Number |
The number to raise to the power of an exponent. |
exponent |
Required |
Number |
The exponent. |
Remarks
Both number and exponent may be non-integers, and they may be negative. If number is not 0 and exponent is 0, this function returns 1. If number is 0 and exponent is negative, this function returns 0.0. If both number and exponent are 0, or if number is negative and exponent is not an integer, this function returns 0.0. If both number and exponent are negative, this function returns -1.#IND.
Example
POW(5,2)
Returns 25.