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 C4, enter an IFS function to calculate the bonus. If sales in cell B4 are less than $15,000, the salesperson earns a 5% bonus. If sales are greater than or equal to $15,000 but less than $25,000, the salesperson earns a 10% bonus. If sales are more than or equal to $25,000, the salesperson earns a 15% bonus. Note: Do not use decimals to represent the bonus percentages. For example, use 5% not 0.05 to represent the bonus if sales are less than $15,000.

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 Programming Questions!