2. In the second scenario for exercise 5 the sales rep commission is based upon
ID: 2779883 • Letter: 2
Question
2. In the second scenario for exercise 5 the sales rep commission is based upon meeting both annual and monthly sales quotas. If the sales rep meets the monthly quota but not the year to date quota their commission is 5% of their monthly sales. However, if the sales rep meets both the year to date and monthly sales quota their commission is 9% of their monthly sales. Write an “if” statement that automatically calculates the reps monthly commission. The sales rep’s year to date sales are $650,000, their year to date quota is $685,000, the monthly sales are $120,000, and their monthly quota is $105,000. You must use one “if” statement to determine the commission.
Explanation / Answer
Statement showing Commission using IF formula
here there is condition that commission will be 9% of monthly sales only if both conditions are satisfied
here D4 = 120,000 and E4 = 650,000( D4 and E4 are cell reference)
Monthly sales Yearly sales Commission Formula 120000 650000 6000 = IF(AND(D4>105000,E4>685000),D4*9%,D4*5%)Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.