# How to use IMPRODUCT Function in Excel

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:

1. The formula returns the #NUM! error if the complex number doesn’t have lower case i or (iota).
2. The formula returns the #VALUE! Error if the complex number doesn’t have correct complex number format.
3. The product of two complex numbers is: READ:  How to use IMLOG2 Function in Excel