In cell B5, enter a formula using defined names to subtract DirectCosts (cell B4) from Revenues (cell B3). In excel
, you can use the following formula:
=Revenues - DirectCosts
This formula will subtract the value in cell B4 (DirectCosts) from the value in cell B3 (Revenues) to calculate the net profit.