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