Try,

=IF(AND(ISNUMBER(H2),H2<18),"Yes","")

Mike

"dave roth" wrote:

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.