Enter a formula in the selected cell to calculate the profit projection for 2022: total sales (cell F4) minus the cost of goods sold (cell F5).

1. Click on the cell where you want to enter the formula. This will be the cell where you want the profit projection for 2022 to appear.

2. Start by typing the equals sign (=). This tells Excel that you are entering a formula, not just a number or text.

3. Click on cell F4 to select it. This cell contains the total sales for 2022. After clicking on the cell, its address (F4) will appear in the formula.

4. Type a minus sign (-) to subtract the cost of goods sold from the total sales.

5. Click on cell F5 to select it. This cell contains the cost of goods sold for 2022. After clicking on the cell, its address (F5) will appear in the formula.

6. Press the Enter key to complete the formula. The profit projection for 2022, calculated as total sales minus the cost of goods sold, will now appear in the selected cell.

So, the formula should look like this: =F4-F5