[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
POWER ( x , y )
Description: Computes x raised to the power y.
Arguments:
Name |
Type |
Description |
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]