Learn How to Use Microsoft Excel IMPOWER Function

Microsoft Excel IMPOWER Function

The prime function of Microsoft Excel IMPOWER function is to raise the complex number to a given power. So, with the help of IMPOWER function you can able to return the raised complex number to a given power. The complex number should be in the form of  "x + yi" or "x + yj". You can also use the COMPLEX function to create complex numbers from real and imaginary parts.  

Return Value of IMPOWER Function

The return value will be the complex number as a text.

Syntax of IMPOWER Function

=IMPOWER(inumber, number)

Where the arguments:

inumber: It is the complex number.

number: It is the power to raise the number.

How to Use Microsoft Excel IMPOWER Function?

As we know the IMPOWER function you can able to return the raised complex number to a given power. The complex number is input in the form text as,  "x + yi" or "x + yj". It should be noted that only lowercase "i" and "j" are accepted by the IMPOWER function and other values will result in a #NUM! error. The number arguments should always be numeric.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel