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 255 arguments.
* You can use the IMSUM function to return the sum of two or more complex numbers.
* You can use the IMSUB function to return the difference of two complex numbers.
* 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!


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