Using the appropriate combination of AND, IF$,$ and$/$or OR$,$ assign bonuses to the employees for column $J$ where an employee satisfies one or more of the criteria. The status displayed should be either "yes" or $"$no$".$ Determine how itany people would qualify for such a bonus in cell J$18.$ Then calculate the total bonus dollars awarded by this criteria in cell $J19,$ given that each employee that satisfies this criteria is awarded $$4,000.$

Using the appropriate combination of AND, IF$,$ and$/$or OR$,$ assign bonuses to the employees for column $K$ where an employee satisfies all $4$ bonus criteria. The status displayed should be either "yes" or $"$no$".$ Determine how many people would qualify for such a bonus in cell $K18.$ Then calculate the total bonus dollars awarded by this criteria in cell $K19,$ given that each employee that satisfies this criteria is awarded $$10,000.$

Hint: Use column L to make sure that your results for Part $2$ make sense.