You work for a company that just completed an online Buy One Get One Free campaign. Your boss would like for you to complete the worksheet. He wants the completed worksheet to make some business decisions: should he do the offer again, what if he offered payments, etc. You will be doing nested functions as well as giving your evaluation. 1. Calculate the total cost for each sale. Remember, it is a buy one, get one free. Also, there are some odd quantities that you need to consider the total cost for the sale (if three items were purchased, two are paid and one is free). The prices for the items are found on the Statistics worksheet. Be sure to use the Retail Price. 2. Get the state tax from the State Sales Tax sheet for each sale. 3. Calculate the tax for each sale. 4. Calculate the Total Sale. 5. Find out which sales are eligible for being paid in payments. If they are eligible put the word Yes in the cell, otherwise leave the cell blank. 6. Create a function that will calculate the payment for 2 payments and 3 payments for only the sales that are eligible for payments. I just need help finding the formula for the row 4 and each columm, from Total Cost to 3 payments.

H4 X fx A B C E F G H M N 0 P Q R 1 2 Online Sales During Buy 1 Get 1 Free Sale Eligible for Payments? Total Sale - >=$50 or in CA State Total Cost State Tax % Tax 2 payment 3 payments No payments Monthly Rate 2 1.25% 3 1.50% 3 Date Quantity 4 6/30/2014 5 6/30/2014 6 6/30/2014 7 6/30/2014 8 6/30/2014 9 6/30/2014 10 6/30/2014 11 6/30/2014 12 6/30/2014 13 6/30/2014 14 6/30/2014 15 6/30/2014 16 6/30/2014 17 6/30/2014 18 6/30/2014 Item 6 Old Bay 4 Old Bay 4 Old Bay 2 Old Bay 2 Original Blend 4 Original Blend 10 Original Blend 12 Original Blend 2 Original Blend 8 Sea Salt and Caramel 8 Sea Salt and Caramel 5 Sea Salt and Caramel 4 Sea Salt and Caramel 2 Truffle 14 Truffle MD MD NJ NJ AL CA NC OH VA MO MS NJ NY DC DC A21 # X fx D E G H Wholesale Cost - Retail Flavor Num items sold Old Bay 1 Flavor 2 Old Bay 3 Original Blend 4 Sea Salt and Caramel 5 Truffle 6 7 B Retail Price - Wholesale Price $ 6.59 $ 1.89 $ 8.15 $ 2.35 $ 8.99 $ 2.50 $ 7.34 $ 2.10 Original Blend Sea Salt and Caramel Truffle 8 MS OH Sales by State Total Sales 9 10 11 12 13 14 15 16 Old Bay Original Blend Sea Salt and Caramel Truffle Total State Tax A B Postal State Tax 1 Code Rate 2 AL 4.00% 3 AK 0.00% 4 AZ 5.60% 5 AR 6.50% 6 CA 7.25% 7 Co 2.90% 8 CT 6.35% 9 DE 0.00% 10 DC 6.00% 11 FL 4.00% 12 GA 4.00% 13 HI 6.00% 14 ID 6.25% 15 IL 7.00% 16 IN 6.00% 17 IA 6.50% 18 KS 6.00% 19 KY 4.45% 20 LA 5.50% 21 ME 6.00% 22 MD 6.25% 23 MA 6.00% 24 MI 6.88%