| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to make cell blank if no data in previous cell
Use the IsBlank() worksheet function in your formula.
(This does not require VBA programming, so these types of questions could/should be posted in the Worksheet.Functions newsgroup.) For example, if cell A2 is blank, then cell B2 would have the formula: =IF(ISBLANK(A2),"",YourFormulaHere) or =IF(ISBLANK(A2),0,YourFormulaHere), with column $B formatted not to show values if they are 0. -- Regards, Bill Renaud |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to make cell blank if no data in that row | New Users to Excel | |||
| Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
| Cell Blank if duplicate value in previous cell | Excel Programming | |||
| Searching for blank cell and populating based on previous data | Excel Programming | |||
| How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
