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:

IMPRODUCT Function 1 - How to use IMPRODUCT Function in Excel

Syntax:  =IMPRODUCT(A2,B2)

Result:

IMPRODUCT Function - How to use IMPRODUCT Function in Excel

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: IMPRODUCT Function in Excel - How to use IMPRODUCT Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *