On 08/29/2011 03:46 PM, NoOp wrote: > On 08/29/2011 10:01 AM, John Jason Jordan wrote: >> OOo 3.3.0 downloaded from Openoffice.org on Fedora 14, x86_64. >> >> I have a simple table in Writer where I want to do some elementary >> math. The table lists stocks, where the second column (B) is the number >> of shares, the third column (C) is the basis (price paid), the fourth >> column (D) is the current price. In the fifth column (E) I want a >> formula that calculates D minus C times B, that is, to show how much >> gain or loss there has been. In the last column (F) I want to calculate >> the total value based on current price, that is, B times C. Here is the >> first line as an example: >> >> A B C D E F >> AGCO 200 43.20 41.25 0.00 0.00 >> >> The formula that I used in E is =sum(D1-C1)*B1. The formula does not >> generate any error messages, but as you can see, it thinks the answer >> is 0.00, where it should be -390.00. The formula that I used for F is >> =sum(B1*D1), but it also displays 0.00 where it should be 8,250.00. >> >> All columns except A are set to general number format. >> >> I can't figure out why the formulas do not calculate the correct >> answers. Any help is welcome. > > A > B > C > D > E > F > AGCO > 200 > 43.2 > 41.25 > 390 = =sum(<C2>-<D2>)*<B2> > 8250 = =<B2>*<D2>
That's what I get for reading by date. I see that JJJ posted this twice & hadn't read this 10:07 AM thread: Subject: Writer can't do arithmetic? Date: Mon, 29 Aug 2011 10:07:35 -0700 Message-ID: <20110829100735.5a83ad42@Devil8> And the start of this thread: Subject: Writer can't do arithmetic? Date: Mon, 29 Aug 2011 10:01:37 -0700 Message-ID: <[email protected]> JJJ, Why the multiple posts? -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
