Chapter 3, Problem 17RA

In cell B6 in the Purchasing sheet, insert the payment function to calculate the monthly payment using cell references, not numbers, in the function, and make sure the function displays a positive result. Apply Accounting Number Format and the Output cell style to cell B6.

Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20