Fisher Company offers discounts for customers who order larger quantities of

product in a single order. Each customer must order units in multiples of

$5$

$0$

$$units$.$

The following table shows the discount for each product

each product sold by Fisher and the minimum quantity required to be ordered

for the customer to receive the discount.

Instructions:

Task A

For each customer, indicate the discount that the customer qualifies for

$($

if any

$)$

$.$

Use the IF and a nested HLOOKUP function.

Task B

For each customer, compute the net purchase cost, subtracting the appropriate discount

$($

if any

$)$

from the gross purchase cost. Use the IF and a nested VLOOKUP function.