[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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:

POWER(2,3) results in 8
POWER(2,0.5) results in 1.414213562
POWER(-1.234,5.0) results in -2.861381721
POWER(1.234,5.1) results in 2.922182358

end example]