![]() This multiplies the monthly lease payments by 12 to calculate the total payments required for the year. Click cell B6 in the Car Lease Payments worksheet.Click the Car Lease Payments worksheet tab.Click cell C5 on the Budget Summary worksheet.The value of multiplying the monthly mortgage payments by 12 is now displayed on the Budget Summary worksheet. The formula in the formula bar should read: =’Mortgage Payments’!B5*12 This multiplies the monthly payments by 12 to calculate the total payments required for the year. Click cell B5 in the Mortgage Payments worksheet.Click the Mortgage Payments worksheet tab. ![]() Click cell C4 in the Budget Summary worksheet.The following steps explain how this is accomplished: As a result, we will create a formula that references cell locations in the Mortgage Payments and Car Lease Payments worksheets. In the Budget Summary worksheet, we need to show the total annual payments. However, you will recall that we used the PMT function to calculate the monthly payments. Figure 9.3.1 Cell Reference Showing the Total Expenses in the Budget Summary WorksheetĪs shown in Figure 9.3.1, the Budget Summary worksheet is designed to show the expense budget for the mortgage payments and the auto lease payments. Notice that the cell reference D12 is preceded by the Budget Detail worksheet name enclosed in apostrophes followed by an exclamation point (‘Budget Detail’!) This indicates that the value displayed in the cell is referencing a cell location in the Budget Detail worksheet. The output of the SUM function in cell D12 on the Budget Detail worksheet will be displayed in cell C3 on the Budget Summary worksheet.įigure 9.3.1 shows how the cell reference appears in the Budget Summary worksheet. Click cell D12 on the Budget Detail worksheet.Click cell C3 in the Budget Summary worksheet.Outputs from the formulas and functions that were entered into the Budget Detail, Mortgage Payments, and Car Lease Payments worksheets will be displayed on the Budget Summary worksheet through the use of cell references. This is how data will be displayed on the Budget Summary worksheet in the Personal Budget workbook. Cell references can also be used to display values or the outputs of formulas and functions in cell locations on other worksheets. So far we have used cell references in formulas and functions, which allow Excel to produce new outputs when the values in the cell references are changed. 9.3 Creating a Budget Summary Worksheet Linking Worksheets (Creating a Summary Worksheet)
0 Comments
Leave a Reply. |