IMPRODUCT function
IMPRODUCT multiplies complex numbers together and returns the product as text. A complex number is one written in x+yi form, such as 3+4i, with a real part and an imaginary part.
Example
Read it as a sentence: multiply the complex numbers in W1:W2 (3+4i and 1-2i), which gives 11-2i.
Excel shows 11-2i
W
1
3+4i
2
1-2i
Data
Syntax
IMPRODUCT(inumber1, [inumber2], ...)
Arguments in [square brackets] are optional.
-
inumber1(required) - The first complex number.
-
inumber2(optional) - More complex numbers to multiply; up to 255.
Returns: The product as text.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=IMPRODUCT("3+4i","1-2i") | 11-2i | Two values |
=IMPRODUCT("1+i","2","3i") | -6+6i | Three values |
=IMPRODUCT({"1+i","2-i"}) | 3+i | Array constant |
=IMPRODUCT("2+i") | 2+i | Single |
=IMPRODUCT(2,3) | 6 | Numbers |
=IMPRODUCT(Data!W1:W2) | 11-2i | Range (W1:W2 i suffix) |
=IMPRODUCT("abc","1") | #NUM! | Invalid |
=IMPRODUCT(TRUE,"1") | #VALUE! | TRUE |
The Data sheet these formulas read
A cell that starts with = holds that formula.
W
1
3+4i
2
1-2i
Data
Watch out for
- Result is text.
Where it works
- Excel
- IMPRODUCT is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .