Replace cells with blank
 

I have created a formula on a timesheet, which I have copied thru to 50
cells, but if there is nothing in one of the cells it copies all of the last
cells number throughout, how do I make this so if the cell is empty, then the
formula cells show as blank, until data is input to the initial cell.
Thankyou

Replace cells with blank
 

diggers

You had an answer to this earlier but I guess you missed it.

Basics of having a cell look blank until/unless a referenced cell has data.

In B1 enter this formula =IF(A1="","",A1)

If A1 is empty, B1 will show blank.

If A1 has data, B1 will show that data from A1.

Adapt to your case.


Gord Dibben Excel MVP

On Wed, 16 Nov 2005 14:33:18 -0800, "diggers"
wrote:

I have created a formula on a timesheet, which I have copied thru to 50
cells, but if there is nothing in one of the cells it copies all of the last
cells number throughout, how do I make this so if the cell is empty, then the
formula cells show as blank, until data is input to the initial cell.
Thankyou