Returns a complex number raised to the nth power in x+yi or x+yj text format.
Syntax
IMPOWER(inumber)
IMPOWER (complex number, 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, its function is to return text format in x+yi or x+yj The nth power of the complex number represented]
Take this table as an example. Now we need to calculate the 3rd power or 2nd power of the complex number in column A. The cursor is positioned at (C2) Cell, click the "Function" button in the menu bar,
Find the IMPOWER function and click "OK";
In the pop-up window box, there are two parameters "complex number" and "power", both of which are required; The "plural number" can be an integer, fraction or negative number, but the cell format must be "numeric". If it is non-numeric, the error value "#NUM!" will be returned;
评论列表(196条)
测试