IMPOWER(inumber, number)

Returns the complex number raised to an integer number.

inumberThe complex number you want to raise to a power.
numberThe power to which you want to raise the complex number.

Remarks

* If "inumber" is not in the form x + yi or x + yj, then #NUM! is returned.
* If "number" is not numeric, then #VALUE! is returned.
* Number can be an integer, fractional, or negative.
* You can use the COMPLEX function to convert real and imaginary coefficients into a complex number.
* In Excel 2010 the accuracy of this function was improved.
* In Excel 2007 the format returned by this function has been changed so that the imaginary part is displayed in consistent scientific notation.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=IMPOWER("2+3i",2) = -5+12i
2=IMPOWER("2+3i",3) = -46+9.00000000000001i
3=IMPOWER("2+3i",4) = -119-120i
4=IMPOWER("2+3i",1) = 2+3i
5=#N/A = #N/A
6=IMPOWER("some text",3) = #NUM!
7=IMPOWER("2+3i","some text") = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top