IMPRODUCT

Returns the result of multiplication of a series of complex numbers.

Sample Usage

IMPRODUCT("1+2i","3+4i")
IMPRODUCT(C5, C6)
IMPRODUCT(A1:C2)

Syntax

IMPRODUCT(complex_number1, [complex_number2,..])

  • complex_number1 - The first complex number to multiply.
  • complex_number2 - [OPTIONAL] Additional numbers or ranges to calculate for the product.

 

Examples

IMPRODUCT("1+2i","3+4i") returns a value of "-5+10i".
IMPRODUCT(C5, C6) returns the product of the complex numbers contained in the two cells: C5 and C6.

Notes

  • The product of two complex numbers is:
    • (a+bi) * (c+di) = (ac-bd) + (ad+bc)i
  • You can multiply complex numbers only if they have the same suffix (i or j).