Payroll

Payroll in 2 tabs: progressive social security and income tax with approximate VLOOKUP (range lookup = 1), dependents, ceiling, employer contributions and each employee's net pay.

Area: Human resources. Level: Advanced.

Functions used: MIN, ROUND, VLOOKUP, MAX, SUMIF, SUM.

• Next project: WBS (work breakdown structure) with costs
• All projects
• Lessons