Using If/And Function to figure out Eligibility of Benefit at a Future Date

Originally Posted by edp428

I take a different approach when I calculate benefit eligibility. If you are trying to determine eligibility when an employee works 240 or more hours and has 90 days of service or more, I would use the following:

=IF(AND(B2>=240,C2>=90),"ELIGIBLE", "NOT ELIGIBLE")

Another tip I would give to make your formula me dynamic is to create named ranges for both the hours trigger as well as the months of service. That way if you need to modify those items at a future date you can change it in the named range and not in the formula itself. It would look something like this:

=IF(AND(B2>=HrsTrigger,C2>=ServiceMonths),"ELIGIBLE", "NOT ELIGIBLE")

Hope it works.

Eric

Thank you, Eric. For some reason this one didn't work.