Amending Formula in a Cell

  1. Place cursor in formula window at the point you wish to make the correction.
  2. Amend the equation so that National Insurance is also subtracted from the Weekly Gross Pay figure.
  3. Select the green tick to confirm the change.
  4. Make the necessary amendment to the formula.
  5. Copy this formula down the column to calculate the National Insurance for each employee.
  6. Your spreadsheet should now appear as below:

Contents: Spreadsheets

Skill Check: Spreadsheets