Returns a complex number raised to the nth power in x+yi or x+yj text format.
Grammar
IMPOWER(inumber)
IMPOWER (plural, power)
IMPOWER function syntax has the following parameters:
Inumber: required, a complex number whose power needs to be calculated.
number: Required, the power to apply to complex numbers.
The previous video taught you how to quickly calculate the exponent of a complex number through the IMEXP function. Today I want to explain how to quickly calculate the integer power of a complex number.
[The function involved here is IMPOWER, which is used to return the nth power of a complex number expressed in x+yi or x+yj text format】
![分界线.png 分界线.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/bccf8f501a092ee62d67745e209abab1.png)
■ Taking this table as an example, now we need to calculate the 3rd power or 2nd power of the complex number in column A, and position the cursor Go to cell (C2) and click the "Function" button in the menu bar,
Find the IMPOWER function and click "OK";
![图片1.gif 图片1.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/30e135857f77f6122e7a82cf657475cd.gif)
■ In the pop-up window box, there are two parameters "complex number" and "power", both of which are required. ;where "complex number" can be an integer, fraction or negative number, but the unit
The format must be "numeric". If it is non-numeric, the error value "#NUM!" will be returned;
![image.png image.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/a25681d87eb33d1146a60b45be6b6644.png)
■ Enter (A2) in the "Plural" item, enter "3" in the "Power" item, and click "OK" ", the third power of the complex number "1+2i" is calculated.
![图片2.gif 图片2.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/a5bf10647eb47f1b6db4ce2edfc430d0.gif)
■ Position the cursor at the lower right corner of cell (C2) and pull down the fill formula when it is in the + font shape. This is required Note that A3-A5 are calculated to the power of 2, and copy
The formula of is to the power of 3; click on cell C3 and change the number of "powers" in the formula to 2. Press Enter and then drop down to fill in the formula to get all the correct results.
![图片3.gif 图片3.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/3b48adedaddd44542f041b1ab6448792.gif)
评论列表(196条)
测试