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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock