Need help how to use the formulas IF, IF(AND), and more formulas. thanks

Payroll-benefits Search Sheet Home Insert Page Layout Formulas Data Review View Calibri (Body)11A A Conditional Formatting Insert Delete Format General GFormat as Table - 00Cell Styles Paste Company Name Years Worked Health Care Retirement Vacation Dental/Wision Discounts ID Employee Name Status A123 A124 A125 A126 A127 Employee1 Employee2 Employee? Employee4 Employee5 Full-time Part-time Full-time Full-time Part-time Totals 1. Health Care: Employees who are full time AND have worked more than five years are eligible to receive health care benefits. Either Yes they are eligible or No they are not. 2. Retirement: Only full time employees receive benefits. If they are eligible write "RET" in the cell or else leave the cell blank. 3. Vacation: All employees who have worked more than five years, receive $200 per year they have worked as a vacation credit, or else they get nothing. Be sure you calculate the full vacation credit for each employee. 4. Dental-Vision: Employees can buy their dental and vision insurance if they are already receiving Health Care benefits for a $20 payrol deduction. Either they pay out $20 or nothing. 5. Discount: Employees who have worked more than 3 years get a 5% discount. Employees who have worked more than 5 years get a 10% discount. Employees who have worked more than 7 years get a 15% discount. Anyone who has vWorked less than 3 years does not get a discount. 10. Total any numbers that need to be. Use the Auto SUM shortcut. 11. Somewhere under your conditional formulas, create the following COUNT functions: 1. the 2. the number of employees who are full-time. 3. the number of employees who are part-time number of employees receiving health care benefits