Using the Excel IMPRODUCT Function

Summary
The 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 Breakdown
Inumber 1Required. The first inumber to multiply.
Inumber 2
Required. Additional inumbers. Up to 255 complex numbers can be entered.
Usage Notes
IMPRODUCT 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.