In this article, you will learn about the IMPOWER function, its usage, syntax and how to use it in your excel spreadsheet.
IMPOWER Function in Excel
The IMPOWER function in Excel returns a complex number raised to a given power.
i.e., the complex function x+yi will be raised to n power times mathematically.
Mathematical equation : zn = (reIθ )n = rn einθ, where Z= x+yi.
= IMPOWER (inumber, number)
- inumber The complex number.
- number The power to which the complex number needs to be raised.
Possible Errors and Usage Notes
- When the number is nonnumeric, IMPOWER returns the #VALUE! error value.
- The number argument should be numeric.
- Number can be an integer, fractional, or negative.
- IMPOWER function accepts lowercase “j” and “i” . Other values in the imaginary part will result in the #NUM error.
How to use the IMPOWER function in Excel?
Using this function in a Worksheet is simple; all you need to do is enter the function as a formula of the cell in the formula bar.
Take a look at the given example
To raise the complex number to a certain power, enter the complex numbers in column A and in Column B, enter the power value to which the complex number needs to be raised. In column C, enter the following formula
Formula: =IMPOWER (A1,B1)
Excel does the mathematical calculation internally and returns the result.
Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the final results.