reference blank cell in formula
 

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

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

--

HTH

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


"Karen" wrote in message
...
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

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

"Bob Phillips" wrote:

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

--

HTH

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


"Karen" wrote in message
...
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