Task #53
Discount by scale
The wholesale discount depends on the order amount according to the scale in E2:F5:
- from $0: 0%;
- from $10,000: 5%;
- from $50,000: 10%;
- from $100,000: 15%.
Find the discount for each order in C2:C9.
The scale may change, so take the percentages from it instead of typing them as numbers.
Task #53
Discount by scale
The wholesale discount depends on the order amount according to the scale in E2:F5:
- from $0: 0%;
- from $10,000: 5%;
- from $50,000: 10%;
- from $100,000: 15%.
Find the discount for each order in C2:C9.
The scale may change, so take the percentages from it instead of typing them as numbers.