Convert every review score into a letter grade for calibration
People-ops needs letter grades on the review roster before the calibration meeting at 2pm. The scale: 90+ A, 80–89 B, 70–79 C, 60–69 D, below 60 F. Nested IFs would work but IFS reads cleanly top-to-bottom and stops at the first true condition.
Multi-bracket performance grade with IFS
Practice using IFS 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.
Performance reviews convert a 0–100 score into letter grades: 90+ A, 80–89 B, 70–79 C, 60–69 D, below 60 F. Nested IFs work but IFS is cleaner.
In C2, return a letter grade for the score in B2: "A" for 90 or above, "B" for 80–89, "C" for 70–79, "D" for 60–69, otherwise "F". End with TRUE as the catch-all condition. Drag the formula down through every employee.
IFS handles multi-branch logic without the nested-IF tangle. You list condition/value pairs in order, and Excel returns the value paired with the first true condition. The clean way to write grade scales, tax brackets, and commission tiers.
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)Try the formula first. Hints cost CP for a reason.