Power()

Working with Formulas > Functions Used in Formulas > Numeric Functions > Power()

POWER() returns the base raised to the power of the exponent. If the input is invalid, the function returns zero.

Function Format

POWER(base, exponent) 

Return Value

POWER() returns a numeric value 

Examples

POWER(3, 2) = 9 

POWER(9, 0.5) = 3 

POWER(3, 0) = 1 

POWER(3, -2) = 0.1111