Excel IMPRODUCT Function

Using the Excel IMPRODUCT Function

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 1
Required. 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.