what is $2$ execel formula Fisher Company offers discounts for customers who order larger quantities of

product in a single order. Each customer must order units in multiples of $50$ 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.

Hints:

Don't forget the data range should be named.

For the LOOKUP functions, remember that the final argument of the function is which row or

column of the data range the result should be retrieved from. The first column included in the

range is column $1,$ the second column is column $2,$ etc. The first row included in the data

range is row $1,$ the second row is row $2,$ etc.$).$ Note that the purchase requirements

are in multiples of $150--$how are you going to equate those to row numbers in the data range?

You're going to have to determine first if the customer even qualifies for a discount.