Tag every rep with bonus eligibility (rating AND tenure)
Comp review wants both signals: a performance rating of 4+ AND at least 2 years of tenure. Either condition missing means no bonus this cycle. Stamp each row before the run kicks off in the morning.
Bonus eligibility: rating AND tenure
Practice using IF to solve a real hr & operations problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
Comp is being reviewed before the bonus run. Eligibility requires BOTH a performance rating of 4 or higher AND at least 2 years of tenure. One missing condition means no bonus this cycle.
In cell E2, return 'Eligible' when the rating in C2 is 4 or higher AND the tenure in D2 is 2 or more. Otherwise return 'Not yet'. Drag the formula down through E9 so every rep is tagged.
IF tests a condition and returns one value if it's true and another if it's false. It's the foundation of every conditional formula in Excel. The condition can use comparison operators (=, <, >, <>), and the two return values can be numbers, text, blanks, or even nested formulas.
IF(logical_test, value_if_true, [value_if_false])Try the formula first. Hints cost CP for a reason.