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> -- ----------------------------------------------------------------- To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help