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";"34i")
The formula =IMPRODUCT(3+i4,3i4) will be regarded as (3+ (value in cell
i4))*(3(value in cell i4)), so it returns 9.
The formula =IMPRODUCT(2+i2,0.5i.5), i.5 is not a valid cell reference, so
#REF returned.
Regards, Shan Zhu
2012/6/7 Dan Lewis <elderdanlewis@gmail.com>
> 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;34j) do not work.
>>
>> Advice? Thoughts?
>>
>> Thank you.
>>
>> Jim Easton
>> 8585270240
>>
> I would not trust IMPRODUCT() to do calculations: they are not
> correct.
> For example, I made this calculation: =IMPRODUCT(3+i4,3i4). 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.5i.5). Calc gives an error: #REF.
>
> Dan
>
>
> ****
> To unsubscribe, email: ooousersunsubscribe@**incubator.apache.org<ooousersunsubscribe@incubator.apache.org>
> For additional commands, email: ooousershelp@incubator.**apache.org<ooousershelp@incubator.apache.org>
>
>
