The Excel IMPOWER Function

Related Function:
IMSQRT Function

Function Description

The Excel IMPOWER function returns a supplied complex number, raised to a given power.

The syntax of the function is:

IMPOWER( inumber, number )

Where the function arguments are:

inumber - The complex number that you want to raise to a given power.
number - The power to which the supplied inumber is to be raised.


Excel Impower Function Examples

The spreadsheets below show five examples of the Excel Impower function:

 Formulas:
  A
1 =IMPOWER( "2-i", 2 )
2 =IMPOWER( "2-i", 3 )
3 =IMPOWER( "5+2i", 2 )
4 =IMPOWER( 9, 0.5 )
5 =IMPOWER( "2+4i", -2 )
 Results:
  A
1 3-4i
2 2-11i
3 21+20i
4 3
5 -0.03-0.04i

Note that, in the above example spreadsheet, the integer 9, used in cell B4, is equal to the complex number 9+0i.


Further details and examples of the Excel Impower function are provided on the Microsoft Office website.


Impower Function Error

If you get an error from the Excel Impower Function, this is likely to be one of the following:

Common Error
#NUM! - Occurs if the supplied inumber is not recognised as a complex number.
#VALUE! -

Occurs if either:

  • The supplied inumber argument is a logical value
or
  • The supplied number is non-numeric.