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:
Based on the Excel spreadsheet above, the following IMPRODUCT examples would return:
- 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: