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. -- Wem Gott will rechte Gunst erweisen, den shickt er in die Wurst-Fabrick. Whom God loves very much, he lets him visit at the deli factory. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
