reference blank cell in formula

K

Karen

I have the following: =IF(H7<=$J$3,"12/31/2006","Not Available"), which works
for the True/False. However, how do I throw in another variable: if H7 is a
blank cell, then "immediately" is the result? thx, Karen
 
B

Bob Phillips

=IF(ISBLANK(H7),"immediately",IF(H7<=$J$3,"12/31/2006","Not Available"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
K

Karen

Bob, thanks a million! Your answer was 100% right on and your response was
extremely quick. Kudos!
Karen
 
Top