Adding formulas and functions
- Leaving a blank row, Paul adds the label ‘Money left’ in cell C6.
- He bolds the text, aligns it to the right and fills the cell in light grey.
- He uses AutoSum to calculate the total for Incoming and Outgoing in cells C5 and D5 respectively. The functions look like this: ‘=SUM(C2:C4)’ and ‘=SUM(D2:D4)’. He colours the totals white so they are hidden.
- In cell D6, to the right of the label 'Money left' he writes a formula: =C5-D5. This subtracts his outgoings from his incomings and shows him how much money he has left.
If his pay, allowance or cost of magazine subscription increases, the ‘Money left’ value will automatically update.
Download a new version of Paul’s spreadsheet with functions and a formula.
