Day 28

Task:

You run payroll for a five-person team at a small design studio. Every paycheck deducts a flat 20% of gross pay for income tax and a further 5% of the same gross pay for the pension scheme. In column C, work out each employee's net pay — using LET to name the gross pay once rather than writing the same cell reference three times over.