Task 1 of 4
In E2:E6, pull the bonus percentage for each position from the lookup table J2:K4.
Lesson theory
A monthly payroll sheet: salary is earned in proportion to the days worked, a position-based bonus from the lookup table is added on top, and then comes the withholding and the net pay.
- Bonus % — VLOOKUP on the table in J:K;
- Gross = ROUND(salary / working days × days worked × (1 + bonus), 0);
- Withheld = ROUND(gross × withholding rate, 0). This is a simple 10% here, not real tax withholding;
- Net pay = gross − withheld.
The parameters (the number of working days and the rate) are in M1:N2, and formulas refer to them with $.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page