by The Excel IMPRODUCT function returns the product of one or more complex numbers. The complex number must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real and imaginary parts
Syntax:= IMPRODUCT(inumber1, [inumber2], …)
The IMPRODUCT function syntax has the following arguments:
- Inumber1, [inumber2], … Inumber1 is required, subsequent inumbers are not. 1 to 255 complex numbers to multiply
Example: Let’s look at some Excel IMPRODUCT function examples and explore how to use the IMPRODUCT function as a worksheet function in Microsoft Excel:
Syntax: =IMPRODUCT(A2,B2)
Result:
Based on the Excel spreadsheet above, the following IMPRODUCT examples would return:
Syntax: =IMPRODUCT(A3,B3)
Result: 12-4i
Syntax: =IMPRODUCT(A4,B4)
Result: 90+120i
Syntax: =IMPRODUCT(A5,B5)
Result: -17-51i
Syntax: =IMPRODUCT(A6,B6)
Result: -11+18i
Syntax: =IMPRODUCT(A7,B7)
Result: -16-37i
Syntax: =IMPRODUCT(A8,B8)
Result: 1+9i
Syntax: =IMPRODUCT(A9,B9)
Result: 8+10i
Syntax: =IMPRODUCT(A10,B10)
Result: 54-99i
Syntax: =IMPRODUCT(A11,B11,C11)
Result: 411-378i
Syntax: =IMPRODUCT(A12,B12,C12)
Result: 75+125j
Syntax: =IMPRODUCT(A13,B13,C13)
Result: -4-58j
Note:
- The formula returns the #NUM! error if the complex number doesn’t have lower case i or j (iota).
- The formula returns the #VALUE! Error if the complex number doesn’t have correct complex number format.
- The product of two complex numbers is:
