Replace cells with blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
help with formula for last input in column 6
Excel formula, sum the value cell and if empty cell left blank 0
Return blank cell if data cell is blank 4
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
#DIV error 2
formula finds values in apparently blank cells 1

Back
Top