Task 1 of 2
In E2:E7, pay a bonus of 500 if sales are at least the target AND tenure is at least 1 year, otherwise 0.
Lesson theory
AND(cond1, cond2)is TRUE if all the conditions are met;OR(cond1, cond2)is TRUE if at least one is met;NOT(cond)flips the result.
They usually go inside an IF:
=IF(AND(B2>=C2,D2>=1),500,0) is a bonus if the target is met and the employee has at least a year of tenure.An empty text value is written as two quotation marks: "".
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