I've been trying to solve this for way too long now, any assistance is appreciated. I need to concatenate two formulas that I have to determine eligibility status for some of our employees.
Condition 1: If people were hired after 7/3/2011, they are not eligible.
Condition 2: If people were hired between 4/1 and 7/3, they are not eligible.
Otherwise, anybody is eligible. I have the two independent formulas working, but cannot seem to merge them. Any help is most appreciated!
tia
Last edited by justinhampton81; 08-12-2011 at 02:33 PM.
Hi,
How about:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
This should do it...
=IF(AND(A5<$A$2,AND(A5>$B$2,A5>$C$2)),"Eligible","Not Eligible")
I got carried away on the ANDs...
HTH
Regards, Jeff
That's what i thought would work:
=IF(AND(A5<$A$2,AND(A5>$B$2,A5>$C$2)),"Eligible","Not Eligible")
but when I tested it against the date 2/28/2011, which should be eligible, the formula produces a "non eligible" result.
The column I have labeled "Formula 1" works fine, however, Formula 2 produces the wrong result. That's where i"m having the issue.
How about:
Cheers,Please Login or Register to view this content.
perfect! thanks Conne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks