[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
IMPOWER ( complex-number , y )
Description: Computes the complex number complex-number raised to the power y.
Mathematical Formula:
![]()
where:
![]()
and:
![]()
and:
![]()
Arguments:
|
Name |
Type |
Description |
|
complex-number |
The complex number in x + yi or x + yj text format. | |
|
y |
number |
The exponent to which complex-number is to be raised. |
Return Type and Value: text – A string containing complex-numbery, in x+yi or x+yj text format.
However, if complex-number is ill-formed, #NUM! is returned.
[Example:
IMPOWER("2.3+4.5i",2.5) results in -52.9752689709953+22.138528463954i
IMPOWER("-1-4j",-3.56) results in 6.34818926783845E-003+1.16156377299512E-003j
end example]