I have been searching forums for help with creating a single cell that returns a result of "Eligible" OR the earliest date that an employee would be eligible for retirement from the organization based on any one of the three variables that are possible. So far I haven't located the help I need, so I joined this forum. Again, I wasn't able to locate the formula I'm seeking on this forum so I apologize if this has been answered somewhere already and would ask to be pointed in that direction. I really like Excel, but am still relatively new at using it. I have 2003 Version at home and 2010 Version at work.
The elgibility variables are:
1. 50 years of age AND at least 20 years of service
2. 55 years of age AND at least 10 years of service
3. Any Age AND at least 25 years of service
Since I haven't been able to figure this out, I made three columns in the attached sheet that return a result of True or False. I was able to manually extract the data I was seeking in this arrangement by viewing everyone's age and years of service and then looking back at dates of birth and start date. I'd like to create a final worksheet that automatically displays "Eligible" OR the earliest DATE that an employee would be eligible for retirement so that the time necessary to extract the data is reduced.
My organization also has another set of criteria for another set of employees:
1. 60 years of age AND at least 10 years of service
2. 65 years of age AND at least 5 years of service
3. Any Age AND at least 30 years of service
I sincerely appreciate any assistance that can be provided.
Dale
Bookmarks