Returns the product of 2 to 29 complex numbers in x + yi or x + yj text format.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
Inumber1,inumber2, … are 1 to 29 complex numbers to multiply.
- Use COMPLEX to convert real and imaginary coefficients into a complex number.
- If inumber1 or inumber2 is not in the form x + yi or x + yj, IMPRODUCT returns the #NUM! error value.
The product of two complex numbers is:
IMPRODUCT("3+4i","5-3i") equals 27 + 11i
IMPRODUCT("1+2i",30) equals 30 + 60i