blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
see other post

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reference blank cell in formula 2
DATEDIF formula enhancement 10
IF with substraction 8
Simple Formula Help 4
nested if statements using "AND" as well as "OR" 2
Warning when in another cell after entering a formula. 2
logic test with nested IF fuctions - help 2
Will FLOOR & CEILING work with variable stratifications? 1

Back
Top