BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points
IF
Returns one value when a test is true and another when it is false.
Syntax
IF(logical_test, value_if_true, value_if_false)
Logical Functions.
A worked example
=IF(D2>=1,"Met","Below")
Returns Below
Returns Met when achievement is 100% or more, otherwise Below.
Where it goes wrong
Comparing a percentage-formatted cell against 100 rather than 1. The cell displays 95% but holds 0.95, so >=100 is never true.
Practise IF
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
- IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points - IntermediateLogical Functions
Approve orders with AND
Require two conditions to be true at once.
IF · AND
8 min25 points - IntermediateDate & Time
Flag overdue invoices with IF and TODAY
Combine date arithmetic with a conditional label.
IF · TODAY
9 min25 points