Simple IF statement???

Experts,

It should be simple, but its not working and even when I search on "multiple IFs" and try using / tweaking, still not working using OR or AND in the IF.  Maybe its a sequence of order?

This is what I need
cell F2 has either a date, or is blank
if F2 <1/1/2012, then Y
if F2 is blank, then N
if F2 is > 12/31/2011, then N

Need quickly (sorry)
AliciaVeeAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
=IF(F2="","N",IF(F2<DATE(2011,12,31),"Y","N"))
0
 
jppintoCommented:
=IF(F2="","N",IF(F2<DATE(2012,1,1),"Y","N"))
0
 
jppintoCommented:
Please take a look at the attached example...
Simple-IF.xlsx
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Saqib Husain, SyedEngineerCommented:
=IF(AND(F2<>"",F2<40909),"Y","N")
0
 
AliciaVeeAuthor Commented:
I tried all 3 examples, in the order that they were posted, and each one has the same issue in that when the date is 12/31/2011, the result should be N, but each is returning Y -- why is that? Help!
0
 
jppintoCommented:
Please check the attached file with the various options as examples for you to see the result of the formulas.

jppinto
Simple-IF.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
I get an N. See attached.
Simple-if.xlsx
0
 
AliciaVeeAuthor Commented:
jppinto -- works!  thanks!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.