Question

In cell B7, create a formula using external and Internal worksheet references, that subtracts cell B9 on the Expenses worksheet of the PB Expenses.xlsx file, from cell B5 on the Income Statement worksheet of the PB Financlals.xlsx file.

Answer 1

To perform a subtraction using external worksheet references, insert the formula ='[PB Financials.xlsx]Income Statement'!B5 - '[PB Expenses.xlsx]Expenses'!B9' in cell B7. Ensure that both the referenced workbooks are open or accessible for the formula to work.

Step-by-step explanation:

To create a formula in cell B7 on one worksheet that subtracts the value in cell B9 on the Expenses worksheet from the value in cell B5 on the Income Statement worksheet, you would typically write a formula that includes external references to another workbook. In this case, you need a formula that references cells from the PB Expenses.xlsx file and the PB Financials.xlsx file. Here's how you could structure the formula:

=Income Statement workbook's B5 cell value minus Expenses workbook's B9 cell value:

='[PB Financials.xlsx]Income Statement'!B5 - '[PB Expenses.xlsx]Expenses'!B9

Place this formula in cell B7 of the appropriate worksheet to perform the subtraction. Remember, for this formula to work, both the PB Financials.xlsx and PB Expenses.xlsx files must be open or the references must be valid and the files accessible.

Answer 2

To subtract a value from one Excel workbook from a value in another, you use a formula that references both workbooks. The formula syntax in cell B7 would be: '= '[PB Financials.xlsx]Income Statement'!B5 - '[PB Expenses.xlsx]Expenses'!B9', with both files open to work properly.

Step-by-step explanation:

To create a formula in cell B7 using external and internal worksheet references that subtracts cell B9 on the Expenses worksheet of the PB Expenses.xlsx file from cell B5 on the Income Statement worksheet of the PB Financials.xlsx file, you would use the following syntax:

= '[PB Financials.xlsx]Income Statement'!B5 - '[PB Expenses.xlsx]Expenses'!B9

Make sure to check the paths of the files to ensure they are correct and that both files are open in Excel for the references to work properly. Also, replace the references as needed if the file names or worksheet names have changed.