Question: 2 . In cell K 6 , write a formula that will determine the sales bonus paid. a . If the % goal reached is

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 bonus is paid.

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

Students Have Also Explored These Related Databases Questions!