Enter formulas into cells C6, D6, and E6 that you can simply copy down to fill in the table. To do so you will have to add a lookup table to the worksheet that reflects the following discount structure: Units ordered 0-50 51-100 101-150 151-200 Discount Percentage None 3% 5% 7% Over 200 10% For example, if a customer orders 200 units and the unit price is $2 per unit, the total price before discount should be $400 and the total price after the discount should be $372. The formulas should be set up so that if the unit price at the top of the worksheet changes, or it the discount percentages change, the values displayed in the table adjust accordingly. Make sure to format the percentages as percentages, and the dollar values as dollar values. (HINT: Use VLOOKUP with the TRUE option)