d

Exercise 5T Determine the following: In the exercise 5 tab, write an "if" statement that determines how much commission the sales rep will earn. Keep in mind that the sales rep only earns commission on sales that exceed his or hers quota. You must use an "if" statement to determine the commission, other methods will not count. The sales reps's sales for the month are $125,000, their monthly quota is $50,000 and their commission rate is 9%. T 1. 2. In the second scenario for exercise 5 the sales rep commission is based upon meeting botlh 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