May 9, 2021
IMPRODUCT Function - How to use IMPRODUCT Function in Excel

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

Leave a Reply

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