Microsoft Office excel 2007 home & stude...

I would like to copy data from a cell in sheet 1 to a cell in sheet 2. I know how to do this, however, if the cell in sheet 1 is empty, then the cell in sheet 2 will have a 0 in it. I want to find out if I can get rid of the 0 in sheet 2 or just have it left blank. Am making a workbook with an invoice for sheet 1 and a shipper for sheet 2. I want to be able copy what I put in for bill to:, ship to, etc from sheet 1 to sheet 2 as well as products ordered. However sometimes there will be blanks on sheet 1 but the formula is still there in sheet 2 and returns a 0. Do not want a 0 if it should be blank. Can you help?

Hi, Use this formula:

=IF(Sheet2!B1="","",Sheet2!B1)The IF statement tests if the cell on the other sheet is empty.

If it is empty (IF condition is true) it returns ""

If it is not empty (IF condition is false) it returns the value in the cell on the other sheet.Regards

Thank you so much that did indeed do what I wanted it to do.

Ask Your Question

Weekly Poll