POWER

Syntax:

POWER ( x , y )

Description: Computes x raised to the power y.

Arguments:

Name

Type

Description

x

number

The base and the number y is the exponent to which that base is raised.

y

number

The exponent to which the base is raised.

Return Type and Value: number – x y.

However, if

  • The value of x is negative and y is not a whole number, #NUM! is returned.

  • x is zero and y is less than or equal to zero, #DIV/0! is returned.

  • The result cannot be represented as a number, #NUM! is returned.

example: