Hi All!!!
I'm new to the Excel Forum. I've used it and referenced it in the past but this is my first post. I'm looking for some help with an IF formula (if its the right one to be using). I'm trying to determine if someone is Eligible for Retirement and also IF they are Eligible for Retirement Benefits
Eligible for Retirement
Current formula: IF($AX5<55,"N",IF($AY5<1,"N","Y"))
Criteria:
- You are age 55 or older (or age 53 if your normal retirement age under the old PP is 63)
- At least 1 year of continuous service
Note: 65 is the 'Normal Retirement Age" with 63 being the 'Normal Retirement Age' under the old Plan. I have a column for the NRA ie. 65 or 63. 55 or 53 would be consider 'Early Retirement Age' but still eligible.
How do I build that into a 'Eligible for Retire" Formula so it captures both situations??
Eligible for Retirement Benefits:
Current formula: =IF($AX5>=10,IF($AX5>=55,IF($AY5+$AX5>=75,"Y","N"),"N"))
Criteria:
- You are age 55 or older (or age 53 if your normal retirement age under the old PP is 63)
- You have 10 or more years of continuous service, AND
- Your Age plus Continuous Full time or part time services equals 75 or more
Any help would be greatly appreciated.
J
Bookmarks