On 29/04/2008 19:17, Henning von Roeder wrote:
On Mon, Apr 28, 2008 at 4:10 PM, <[EMAIL PROTECTED]> wrote:
I just downloaded OpenOffice for the first time. I am new to this and even
new to doing much with spreadsheets. If I knew more about them, I'd be able
to find what I'm looking for. I'm trying this approach to see if I get any
helpful info back.
I am creating a spreadsheet that has a few columns of currency amounts.
Then I have a 3rd column that sums each row of the first two columns. I've
formatted the summed column as currency with red for negative numbers,
thousands
separator, and two decimal columns (typical for currency). The only problem
I am having is that each of the formatted/summed cells prints out "$.00" in
each cell where the currency fields are blank. ie: They are all blank until
I have entered info into them, so until then, the calculated field contains
the unwanted "$.00".
I'm sure there must be some way of using 'if then' or 'if blank' so that
nothing is printed in the summed field until data is entered into the currency
amount fields.
HELP. Thanks for any suggestions in advance.
Ken
**************Need a new ride? Check out the largest site for U.S. used car
listings at AOL Autos.
(http://autos.aol.com/used?NCID=aolcmp00300000002851)
if you have column A and want to add column B and display the result
in column C
you enter the following in the first cell of column C and the copy it
down the column for as many entries as you need
=IF((A1+B1=0);"";(A1+B1)) if you enter this in Cell C1 you will get
the desired result
if A1 = 1 and B1 = 2 C1 will be 3, if on the other hand A1 = 2 and B1
= -2, you will see nothing.
This also works for negatives.
Forwarding to unsubscribed OP.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
