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 takes up two or more complex numbers( real component and imaginary component) and calculates product of them (multiply them)
Result
NOTE: #NUM! – Error occurs if,
- supplied inumber arguments are not recognized as a complex number.