subject
Business, 18.07.2020 18:01 LeandraMiller3398

The bonus rates for each salesperson are determined by sales amounts using the following scale:. Sales greater than $35,000 earn a bonus rate of 5%, sales greater than $25,000 earn a bonus rate of 4%.
All other sales (any amount greater than 0) earn a bonus rate of 2%.
With the sheets still grouped, in cell C5 use an IFS function to determine the commission rate for the first salesperson whose sales are in cell B5.
Fill the formula down through cell C8.

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 14:00
Before downloading a new app on your phone, you need to pay attention to
Answers: 2
question
Business, 22.06.2019 06:30
If the findings and the results are not presented properly, the research completed was a waste of time and money. true false
Answers: 1
question
Business, 22.06.2019 17:30
If springfield is operating at full employment who is working a. everyone b. about 96% of the workforce c. the entire work force d. the robots
Answers: 1
question
Business, 22.06.2019 18:30
Hilary works at klothes kloset. she quickly the customers, and her cash drawer is always correct at the end of her shift. however, she never tries to "upsell" the customers (for example, by asking if they would like to purchase earrings to go with the shirt they chose or by suggesting a purse that matches the shoes they are buying). give hilary some constructive feedback on her performance.
Answers: 3
You know the right answer?
The bonus rates for each salesperson are determined by sales amounts using the following scale:. Sa...
Questions
Questions on the website: 13722367