View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
diggers
 
Posts: n/a
Default 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