Question: In cell C 4 , enter an IFS function to calculate the bonus. If sales in cell B 4 are less than $ 1 5
In cell C enter an IFS function to calculate the bonus. If sales in cell B are less than $ the salesperson earns a bonus. If sales are greater than or equal to $ but less than $ the salesperson earns a bonus. If sales are more than or equal to $ the salesperson earns a bonus. Note: Do not use decimals to represent the bonus percentages. For example, use not to represent the bonus if sales are less than $
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
