multiple nested IF statements
 

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.

multiple nested IF statements
 

=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" wrote in message
oups.com...
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.

multiple nested IF statements
 

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"

multiple nested IF statements
 

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

multiple nested IF statements
 

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