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)
