Formula Modification Help with And/OR

[JackChang]

All, I need a little bit more help on this payroll file using AND/OR conditions (attached).

Column D should show 'Yes' for an employee that is enrolled in Medical and works < 20 hours in any of the past 4 weeks (not necessarily all 4 weeks). So, on the file attached cell D8 should show 'yes' because he has medical (column A), and in week 34 (col K), he worked less than 20 hours.


Could someone help me update the formula?

Thank you.

[Paul_Hossler]

If I'm understanding



=IF(AND(A8="Medical",OR(J8<20,K8<20,L8<20,M8<20)),"Yes","Nope")



28993

[JackChang]

Thanks for your help, Paul! Hope you have a wonderful evening.