Related Function:

The IMPRODUCT function returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.


=IMPRODUCT(inumber1,[inumber2], … )


Argument Description
[inumber2] …
1 to to 255 complex numbers to multiply. inumber1 is required, subsequent inumbers are not.

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.


  A B C D
1 Data Formula Result Notes
2 3+4i =IMPRODUCT(A2,A3) 8+19i Product of two complex numbers
3 4+i =IMPRODUCT(“3+4i”,”4+i”) 8+19i  
4   =IMPRODUCT(“2-i”,”4-i”) 7-6i  
5   =IMPRODUCT(COMPLEX(4,1),COMPLEX(2,1)) 7+6i  
6   =IMPRODUCT(A2,10) 30+40i Product of a complex number and 10

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

When multiplying two complex numbers a+bi and c+di, the calculation is as follows:

    \[   (a+bi) (c+di) = (ac-bd) + (ad+bc)i  \]

See Wikipedia for more information on complex numbers.