View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dave roth dave roth is offline
external usenet poster
 
Posts: 10
Default If, And, Isnumber statement

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.