multiple nested IF statements

  • Thread starter Thread starter jazzydwit
  • Start date Start date
J

jazzydwit

Hi.
This may be simple, (and hope you understand what I am trying to do)
but I can't get it to work.
Basically, I am trying to determine if a person is eligible based on
hire or rehire dt but also may or may not be based on basic or nonbasic
dt. I have HIRE (A2), REHIRE (B2), BASIC (C2) and NONBASIC (D2) dt.
How do I set up nested IF statements to determine if HIRE or REHIRE dt
is < = than 1/4/05? If eligible, Yes. And if BASIC OR NONBASIC dt is
= >1/4/05, Check. Thanks.
 
=IF(OR(OR(HIRE<=DATE(2005,4,1),REHIRE<=DATE(2005,4,1)),OR(BASIC>=DATE(2005,4
,1),NONBASIC>=DATE(2005,4,1))),"yes","no")

is my best guess at what you are saying

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Actually, I am trying to use the IF statement for dates. My logic is if
A2 =<"1/4/2005", yes. If not, no. When I use the IF statement for the
dates i have, results are return as "yes". However, i do have dates
that is greater than 1/4/2005, which results should return as "no"
 
Back
Top