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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning date instead of 'not null'
Use this instead
=IF('TRACKER '!$AR7="",'TRACKER '!$B7,"") ISBLANK only works for empty cells not cells with formulas -- Regards, Peo Sjoblom "Skeeterj" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning date instead of 'not null'
If the formula in AR7 returns a formula blank then the ISBLANK function
evaluates to FALSE. ISBLANK is incorrectly named. It should've been named ISEMPTY. There is a difference between an empty cell and a "blank" cell although Excel seems to think they're the same sometimes!!! Try it like this: =IF(COUNT('TRACKER'!$AR7),'TRACKER'!$B7,"") -- Biff Microsoft Excel MVP "Skeeterj" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning date instead of 'not null'
ISBLANK() will not return true if you have a formula in that cell. Try
=IF(ISNUMBER('TRACKER '!$AR7),'TRACKER '!$B7,"") If this post helps click Yes --------------- Jacob Skaria "Skeeterj" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning date instead of 'not null'
Thats got it! Thank you.
Steve "Jacob Skaria" wrote: ISBLANK() will not return true if you have a formula in that cell. Try =IF(ISNUMBER('TRACKER '!$AR7),'TRACKER '!$B7,"") If this post helps click Yes --------------- Jacob Skaria "Skeeterj" wrote: 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 |
Reply |
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 |