Daily challenge · Tuesday 21 October 2025
Complete the PAYG tax schedule
Fill in the missing formulas so each employee automatically picks up the correct tax rate, calculates tax owed, and shows their take-home pay.
In C2 use =VLOOKUP(B2,$H$2:$I$5,2,TRUE) and fill it down so each salary picks the closest lower bound. In D2 multiply the salary by the looked-up rate (for example =B2*C2) and in E2 subtract that tax from the salary (for example =B2-D2). Make sure the lookup table stays locked with $ signs before you copy.