2012/6/7 Shan Zhu
> Getting 9 as a result, it causes by incorrect parameter format in your
> formula.
> The complex number should be put in a pair of double quotation marks, like
> this:=IMPRODUCT("3+4i";"3-4i")
> The formula =IMPRODUCT(3+i4,3-i4) will be regarded as (3+ (value in cell
> i4))*(3-(value in cell i4)), so it returns 9.
> The formula =IMPRODUCT(2+i2,0.5-i.5), i.5 is not a valid cell reference, so
> #REF returned.
>
> Regards, Shan Zhu
>
Shan Zhu's instructions work fine for me ; after clicking the cell into
which I wish to enter the desired product, I then click the functions-guide
icon (*f(x)*) at the top of the spreadsheet, select «IMPRODUCT» from the
left panel in the box that then displays, and click «Next» in the bottom
row. In the right panel a list entitled «Complex numbers» now appears ; I
enter the complex numbers (in the form "a+bi") I wish to multiply into the
the boxes (which are ordered «Complex mumber, Complex number1, Complex
number2,», etc,) in the list, after which the result of the operation
appears in the «Result box». To move this result into the cell I've picked,
I then click «OK» in the bottom row.
«IMPRODUKT("3+4i";"3-4i";"3+4i";"3-4i")» entered in this manner gives 625
as the product, which seems entirely satisfactory to me. But don't forget
those double quotation marks !...
Henri