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 Financials.xlsx file

Answer 1

A formula in cell B7 to subtract cell B9 on the Expenses worksheet in PB Expenses.xlsx from cell B5 on the Income Statement worksheet in PB Financials.xlsx is written as ='[PB Financials.xlsx]Income Statement'!B5 - '[PB Expenses.xlsx]Expenses'!B9.

Step-by-step explanation:

To create a formula in cell B7 that references cells from different worksheets in different workbooks, you will need to use both external and internal references in Microsoft Excel. Assuming that both the PB Expenses.xlsx and PB Financials.xlsx files are open or are located in the same directory, here's how you would write the formula:

In cell B7 of the requested sheet, you would enter the formula:

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

This formula takes the value in cell B5 from the Income Statement worksheet within the PB Financials.xlsx workbook and subtracts the value in cell B9 from the Expenses worksheet within the PB Expenses.xlsx workbook. Remember, if the workbooks are not open or not in the same directory, you will need to include the full file path before the workbook name in the formula.