[libreoffice-users]

[ultraxlnt-domai20044888@yahoo.com]

> =IMPRODUCT(2+i2,2-i2)
>Excuse me, but I believe the terms +2*i2 and -2+i2 do in fact cancel

should be written:
(2+2i)(2-2i)
2*2 + 2*2i + -2*2i + (-4i^2)
=4          +         (-4)(-1)
=8


--- On Wed, 6/6/12, JOE CONNER <joeconner2007@gmail.com> wrote:

> From: JOE CONNER <joeconner2007@gmail.com>
> Subject: Re: [libreoffice-users] IMPRODUCT() does not work in Calc
> To: users@global.libreoffice.org
> Date: Wednesday, June 6, 2012, 8:33 PM
> 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
> 
> -- 
> 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
> 
> 

-- 
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