Question: 2. In cell K6, write a formula that will determine the sales bonus paid. a. If the % goal reached is greater than 150%, then
2. In cell K6, write a formula that will determine the sales bonus paid. a. If the % goal reached is greater than 150%, then a bonus is 3% of the total 2022 sales is paid. b. If the % goal reached is less than or equal to 150% but greater than or equal to 125%, then a bonus of 2% of the total 2022 sales is paid. c. If the % goal reached is less than 125% but greater than or equal to 100%, then a bonus of 1% of the total 2022 sales is paid. d. If the % goal reached is less than 100%, then no bonu
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
