| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning date instead of 'not null'
Greetings all. I am trying to get a return in an "IF" statement only if the
cell has a date in it. The cell has a formula that pulls from a third cell. How do I get a response only if a date has been filled in? =IF(ISBLANK('TRACKER '!$AR7),'TRACKER '!$B7,"") Cell $AR7 has a formula in it that scans a range of cells and fills in a date if they are all populated. The above formula always leaves a blank because of the formula in the AR7 cell. Suggstions? Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
| How suppress chart points - cells with formulae returning null | Charts and Charting in Excel | |||
| VBA returning "Null" for TextBox.Font.Size | Charts and Charting in Excel | |||
| Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
| If Date Null Show Nothing | Excel Worksheet Functions | |||
Threaded Mode
