Module 3 · Lesson 9
IF and business rules
Return different outcomes when a target is met or missed.
Write the rule in plain language first
State what should happen when the condition is met and what should happen otherwise. Then translate that sentence into the three IF arguments.
=IF(B2>=C2,"Met","Review")Test both outcomes
Change an input so the rule returns the opposite result. A formula is not fully checked until both the true and false branches work.
- Use quotes around text results.
- Check >= versus > carefully.
- Test a value exactly on the boundary.
Key takeaway: An IF formula contains a test, the result when true, and the result when false.