Replace cells with blank

D

diggers

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
 
G

Gord Dibben

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
 
Top