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.