a. To calculate the discount, create a formula that uses the following logic: i. If the...

Transcribed Image Text:

a. To calculate the discount, create a formula that uses the following logic: i. If the quantity ordered for an item is less than 5, no discount is applied to that item's total. ii. If the quantity ordered for an item is 5 or more, but less than 10, a 5% discount is applied to that item's total. iii. If the quantity ordered for an item is 10 or more, a 7.5% discount is applied to that item's total. a. To calculate the discount, create a formula that uses the following logic: i. If the quantity ordered for an item is less than 5, no discount is applied to that item's total. ii. If the quantity ordered for an item is 5 or more, but less than 10, a 5% discount is applied to that item's total. iii. If the quantity ordered for an item is 10 or more, a 7.5% discount is applied to that item's total.

Answer rating: 100% (QA)

SOLUTION The formula to calculate the discount based on the quantity ordered c... View the full answer