The formula will subtract the value in cell B4 from the value in cell B3 and display the result in cell B5.
To subtract direct costs cell B4 from revenues cell B3 using defined names in cell B5, follow these steps:
Define the names for the cells:
a. Select cell B3 and go to the "Formulas" tab.
b. Click on the "Define Name" button.
c. In the "Name" box, enter "Revenues".
d. Click "OK".
e. Repeat steps a-c for cell B4, but name it "DirectCosts".
Enter the formula in cell B5:
a. Select cell B5.
b. Enter the following formula:
=Revenues - DirectCosts
c. Press Enter.
The formula will subtract the value in cell B4 from the value in cell B3 and display the result in cell B5.