A sporting goods store discounts every item in its store based on the original price of the item. An item is discounted: 10% if its original price is less than $20, 20% if its original price is greater than or equal to $20 but less than or equal to $75, 25% if its original price is greater than $75. Which function represents the discount of an item, expressed in dollars, with an original price of x dollars?

Question

Business

Rashad Ford

16 November, 19:25

A sporting goods store discounts every item in its store based on the original price of the item. An item is discounted: 10% if its original price is less than $20, 20% if its original price is greater than or equal to $20 but less than or equal to $75, 25% if its original price is greater than $75. Which function represents the discount of an item, expressed in dollars, with an original price of x dollars?

+5

Answers (1)

Know the Answer?

Lyric Mccoy · Answer 1

The function to be used in excel represents the discount of an item expressed in dollars, with an original price of x dollars, is as below:

=if (x$75,25%*x, 20%*x)

in which

10%*x is discount of any items with original price is less than $20 20%*x is discount of any items with original price is greater than or equal to $20 but less than or equal to $75) is 20% discounted 25%*x is discount of any items with original price is greater than $75

Explanation:

We define easy conditions first, then the most complicated at the end

An item is discounted: 10% if x is less than $20 An item is discounted 25% if x is greater than $75 The rest which not any of above (greater than or equal to $20 but less than or equal to $75) is 20% discounted)