Need to create a formula on excel using (if / countif/and/or/vlookup functions to get the union mandate formula

3. Union Mandate Bonus Since all the salespersons with Car More are part-time employees, the union has mandated an extra bonus if more than a certain percentage of the sales staff worked, on average, more than 20 hours a week. The current policy states that any salesperson that worked, on average, more than 20 hours a week will receive an extra $500 in bonus if more than 60% of the sales staff met the criteria. Task: Create an Excel workbook that will calculate the year-end bonuses for the salespersons (with the following conditions): The workbook needs to be able to easily accommodate policy changes regarding the three types of bonuses. Since the data will be entered by a staff in the HR department, the workbook needs to be setup so that the formulae cannot be changed accidentally. . . . The workbook needs to "hide" the bonus criteria from un-authorized personnel. 3. Union Mandate Bonus Since all the salespersons with Car More are part-time employees, the union has mandated an extra bonus if more than a certain percentage of the sales staff worked, on average, more than 20 hours a week. The current policy states that any salesperson that worked, on average, more than 20 hours a week will receive an extra $500 in bonus if more than 60% of the sales staff met the criteria. Task: Create an Excel workbook that will calculate the year-end bonuses for the salespersons (with the following conditions): The workbook needs to be able to easily accommodate policy changes regarding the three types of bonuses. Since the data will be entered by a staff in the HR department, the workbook needs to be setup so that the formulae cannot be changed accidentally. . . . The workbook needs to "hide" the bonus criteria from un-authorized personnel