--- 原始郵件 ---
主旨: Re: [libreoffice-users] IMPRODUCT() does not work in Calc
從: Jay Lozier
到: users@global.libreoffice.org
日期: Wed, 06 Jun 2012 23:02:05 -0400
> On 06/06/2012 10:07 PM, Dan Lewis wrote:
>> IMPRODUCT() is suppose to calculate products of complex numbers.
>&g
o be any
reasonable way around this in Calc.
-Original Message-
From: Jay Lozier [mailto:jsloz...@gmail.com]
Sent: Wednesday, June 06, 2012 20:02
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] IMPRODUCT() does not work in Calc
On 06/06/2012 10:07 PM, Dan Lewis wro
On 2012-06-07 15:33, JOE CONNER wrote:
On 6/6/2012 08:02 PM, Jay Lozier wrote:
On 06/06/2012 10:07 PM, Dan Lewis wrote:
IMPRODUCT() is suppose to calculate products of complex numbers.
However, its answers are not correct: only the real portion of the
complex numbers seem to be used.
On 6/6/2012 08:02 PM, Jay Lozier wrote:
On 06/06/2012 10:07 PM, Dan Lewis wrote:
IMPRODUCT() is suppose to calculate products of complex numbers.
However, its answers are not correct: only the real portion of the
complex numbers seem to be used.
=IMPRODUCT(2+i2,2-i2)
On 06/06/2012 10:07 PM, Dan Lewis wrote:
> IMPRODUCT() is suppose to calculate products of complex numbers.
> However, its answers are not correct: only the real portion of the
> complex numbers seem to be used.
> =IMPRODUCT(2+i2,2-i2)
> = 2*2+2*i2-2*i2-i2*i2
> =
IMPRODUCT() is suppose to calculate products of
complex numbers. However, its answers are not correct: only
the real portion of the complex numbers seem to be used.
=IMPRODUCT(2+i2,2-i2)
= 2*2+2*i2-2*i2-i2*i2
= 4 +i4 -i4 -(4) [i2*i2=-4]
= 8
B