IMPRODUCT

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.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!


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