Re: Writer can't do arithmetic?

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 [email protected]
For additional commands send email to [email protected]
with Subject: help