Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
good morning;
I need to write a statement along the lines of : =IF(AND(ISNUMBER(H2),H2<18),"Yes","No"). H2 contains the formula "=IF(A2<"",DATEDIF(G$2:G$65536,A$2:A$65536,"y")," ")" Obviously, Columns A and G contain dates, which are populated on an ongoing basis, not a static set of dates. H2 will not have a number until A2 and G2 are populated. The If, And, Isnumber formula returns Yes or No, but when I copy it down the column to say, row 44 while the H column is blank, it returns "No"; what I would like it to do is remain blank until H2 contains a number value. XL 2007, Win Xp Pro. Thank you very much for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ISNUMBER QUESTION | Excel Discussion (Misc queries) | |||
ISNUMBER | Excel Worksheet Functions | |||
{=COUNT(--ISNUMBER(G95:G98))} | Excel Discussion (Misc queries) | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions |