a. In cell G6, trace the errors in the formula to identify the cause of the error message. Correct the formula so that the IF function tests whether the contract date (the range named Contract_Tampa) is less than the date in cell B3. If it is, multiply the standard price (cell F6) by the sale price rate (cell G3) and return the result. If it is not, return the standard price (cell F6) in cell G6. b. Copy the formula in cell G6 into the range G7:G14 to fix the errors in that range. c. In cell G15, use Error Checking to find the formula error, and then correct the formula.

d. Correct the formula error in cell F15.

SmartEnergy Services Service Agreements - Quarter 1 Discount offered for purchases before: 2/15/2021 Sale price rate: 87.15% Contact Name Dean Foley Rafael Nunez Ahmad Farrah Charlene Ingersoll Lei Song Greg Spahn Ron Remish Kerry Johnson Brianna Gaines Totals Invoice Number 2101 2557 2254 2479 2086 2699 2158 2265 2077 Contract Equipment Expiration Date Code Date 1/5/2021 101 1/5/2022 1/7/2021 104 1/7/2022 1/9/2021 105 1/9/2022 2/1/2021 103 2/1/2022 2/8/2021 102 2/8/2022 3/1/2021 101 3/1/2022 3/10/2021 101 3/10/2022 3/17/2021 104 3/17/2022 3/21/2021 104 3/21/2022 Standard Price $588.00 $819.00 $819.00 $395.00 $735.00 $588.00 $588.00 $819.00 $819.00 $6,170.00 Sale Price $512.44 $713.76 $713.76 $344.24 $713.76 $588.00 $588.00 $819.00 $819.00 $0.00