multiple nested IF statements

[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.

 

[Bob Phillips]

=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)

 

[jazzydwit]

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"

 

[jazzydwit]

Sorry, but I continue to "yes" for all my dates.

 

[jazzydwit]

IT WORKED!! Some of my dates were not formatted correctly. THANKS!!