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.
Just a though here. Did you make sure that the cells that contain
numbers is formated for numbers? A table in Writer does not work the
same as in Calc. I would suggest using Calc instead.
HTH
Andy
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
