Question: 2 . In cell K 6 , write a formula that will determine the sales bonus paid. a . If the % goal reached is
In cell K write a formula that will determine the sales bonus paid.
a If the goal reached is greater than then a bonus is of the total sales is paid.
b If the goal reached is less than or equal to but greater than or equal to then a bonus of of the total sales is paid.
c If the goal reached is less than but greater than or equal to then a bonus of of the total sales is paid.
d If the goal reached is less than then no bonus is paid.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
