> =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 <[email protected]> wrote: > From: JOE CONNER <[email protected]> > Subject: Re: [libreoffice-users] IMPRODUCT() does not work in Calc > To: [email protected] > 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: [email protected] > 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: [email protected] 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
