BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points
Fix a broken commission formula
The situation
A colleague at Harbor Supply built the commission column before going on leave. Payroll noticed the numbers look wrong for the top performers, and the run is on Friday.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Rep | Sales | Rate | Commission | |
| 2 | Dana Whitfield | $143,000 | $7,150 | ||
| 3 | Marcus Bell | $95,000 | |||
| 4 | Priya Raman | $118,000 | |||
| 5 | |||||
| 6 |
Functions in this exercise
- IF — Returns one value when a test is true and another when it is false.
Who this is for
Recommended next
Related exercises
- IntermediateLogical Functions
Apply commission tiers with IFS
Return the right rate from several tiers without nesting.
IFS
10 min25 points - IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points - BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points