Re: [libreoffice-users] IMPRODUCT() does not work in Calc

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.
> > >            =IMPRODUCT(2+i2,2-i2)
> > >            = 2*2+2*i2-2*i2-i2*i2
> > >            = 4 +i4 -i4 -(4)          [i2*i2=-4]
> > >            = 8
> > > But Calc lists the answer as 4.
> > >
> > >       Are there any complex functions that really work other than
> > > IMREAL()? (It only reads the real part of a complex number.
> > >
> > > --Dan
> > I confirm this result with 3.5.4.2, Ubuntu 12.04
> Excuse me, but I believe the terms +2*i2 and -2+i2 do in fact cancel 
> each other out.
> This leaves 2*2 and -(-4) as the remaining terms, or 4 + 4 = 8.
>
> Or, have I missed something?
>
> Joe Conner, Poulsbo, WA USA
Hi. Just checked the help, its all there.
=IMPRODUCT("2+2i","2-2i")

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted