IMPRODUCT(inumber1 [,inumber2])

Returns the product of two or more complex numbers.

inumber1The first complex number.
inumber2(Optional) The second complex number.

Remarks

* If "inumber1" or "inumber2" is not in the form x + yi or x + yj, then #NUM! is returned.
* You can have a maximum of 29 arguments.
* You can use the COMPLEX function to convert real and imaginary coefficients into a complex number.
* In Excel 2007 the format returned by this function has been changed so that the imaginary part is displayed in consistent scientific notation.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=IMPRODUCT("3+4i","5-3i") = 27+11i
2=IMPRODUCT("1+2i",30) = 30+60i
3=IMPRODUCT("1+2j",15) = 15+30j
4=IMPRODUCT("1+2j","1+2j") = -3+4j
5=IMPRODUCT("some text",15) = #NUM!
6=IMPRODUCT("1+2j","some text") = #NUM!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top