Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace cells with blank
You should be able to use the IF function for this. Something like:
=if(formula=undesired result,"",formula) If you provide more detail about your formula I should be able to give you a more specific solution. "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) |