Documentation/How Tos/Calc: IMPRODUCT function
From Apache OpenOffice Wiki
< Documentation | How Tos
IMPRODUCT
Returns the product of complex numbers.
This function is only available if the Analysis AddIn is installed.
Syntax:
IMPRODUCT(complexnum1; complexnum2; ... complexnum29)
- complexnum1, complexnum2 ... are text representing up to 29 complex numbers, for example as a+bi or a+bj.
- IMPRODUCT returns complexnum1*complexnum2*... as text.
- IMPRODUCT also accepts references to ranges containing complex numbers.
Example:
IMPRODUCT("2-3i"; "4+2i")
- returns 14-8i as text.
IMPRODUCT(A1:A2)
- where cell A1 contains 2-3i and cell A2 contains 4+2i returns 14-8i as text.
See also:
Issues:
- This function currently appears in the AddIn category of the Function Wizard.