Edit

Share via

POW Function

  • Article

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.