Hi an old file made with OOo2 in 2009. It should work. It contains nearly all usual features about complex in elec http://campuslibre.educoo.org/courses/BACPROM/document/9B_Nombres_complexes/complexes.ods I hope that localisation (translation) of used functions will be ok if useful... Fred Juan Diaz ===================== 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 > > > 2012/6/7 Dan Lewis > >> Easton, William wrote: >> >>> I am having difficulties trying to do complex number calculations. >>> >>> First, it is a real pain to have to use functions for ordinary >>> operations. I would like to propose a simple switch that might pop up if >>> a >>> complex number were detected substituting the complex versions of >>> *,/,+,- >>> for the real counterparts. Even more radical would be to do the same for >>> functions, but one might need a compatibility mode. >>> >>> However, I am finding that things like improduct(1+2j;3-4j) do not work. >>> >>> Advice? Thoughts? >>> >>> Thank you. >>> >>> Jim Easton >>> 858-527-0240 >>> >> I would not trust IMPRODUCT() to do calculations: they are not >> correct. >> For example, I made this calculation: =IMPRODUCT(3+i4,3-i4). The answer >> given was 9. But this is just the product of the real numbers. The >> correct >> answer is 25 (3*3 +3*i4 -3*i4 +4*4). >> I also discovered that it may not work with fractions: >> =IMPRODUCT(2+i2,0.5-i.5). Calc gives an error: #REF. >> >> --Dan >> >> >> ------------------------------**------------------------------**--------- >> To unsubscribe, e-mail: >> ooo-users-unsubscribe@**incubator.apache.org >> For additional commands, e-mail: >> ooo-users-help@incubator.**apache.org >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org For additional commands, e-mail: ooo-users-help@incubator.apache.org