␡
- Name the Sheet
- Understand References
- Enter Information
- Activate a Cell
- Enter Row Headings
- Enter Column Headings
- Make a Column Wider
- Enter Values
- Calculate a Difference
- Calculate a Percent Diff
- Sum Some Values
- Calculate Net Income
- Copy Formulas
- Copy and Paste
- Use the Fill Handle
- Change a Value
- Extra Bits
This chapter is from the book
Calculate Net Income
The final row of the worksheet contains cells to calculate the net income (total income minus total expenses). Here’s how to enter that final formula:
- Activate cell B28.
- Type =.
- Click cell B6. Its reference appears in the formula in cell B28.
- Type –.
- Click cell B27. Its reference appears in the formula in cell B28.
- Press Enter. The result of the formula appears in cell B28.
Have you been saving your work?
Now is a good time to click the Save button on the Quick Access toolbar to save your work up to this point.