Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) |