IMPRODUCT Function in Excel – Product of complex numbers in Excel

IMPRODUCT Function in Excel returns the product of two or more complex numbers. IMPRODUCT Function can multiply up to 255 complex numbers.

Multiplication of Complex numbers:

The product of two complex numbers a+bi and c+di is: (a+bi) * (c+di) = (ac-bd) + (ad+bc)i

 

Syntax of IMPRODUCT Function in Excel 

IMPRODUCT( inumber1, inumber2, … )

Where

  • inumber – arguments are the Complex Numbers that you want to multiply.

 

Example of IMPRODUCT Function in Excel

Formula

IMPRODUCT Function in Excel 1

  • IMPRODUCT Function takes up two or more complex numbers( real component and imaginary component) and calculates product of them (multiply them)

Result

IMPRODUCT Function in Excel 2

NOTE: #NUM! – Error occurs if,

  • supplied inumber arguments are not recognized as a complex number.

previous-small IMPRODUCT Function in Excel                                                                                                                 next_small IMPRODUCT Function in Excel