Using the Excel IMPRODUCT Function
SummaryThe Excel IMPRODUCT function returns the product of one or more complex numbers, up to 255 numbers, in the text format x + yi or x + yj.
Use the COMPLEX function to convert real and imaginary coefficients into a complex number.
Syntax=IMPRODUCT (inumber1, [inumber2], ...)
Syntax BreakdownInumber 1
Required. The first inumber to multiply.
Required. Additional inumbers. Up to 255 complex numbers can be entered.
Usage NotesIMPRODUCT returns the product of up to 255 complex numbers that are input as text in the format of x + yi or x + yj.
The function only accepts lowercase "i" and "j". Other values will return the #NUM! error.