Conditional formula
An IF-style function evaluates a logical condition and selects one of two specified outcomes; nested tests can express more cases. Check comparison operators, boundaries and references, and specify what should happen when inputs are missing or invalid.
Worked example
If B2 contains sales of $1,200, =IF(B2>=1000,100,0) returns a $100 bonus; sales of exactly $1,000 also meet the condition.
Common mistake
Using > when the policy includes the threshold, or treating a blank input as a verified zero without checking it.
Where it appears in your exams
| Qualification | Exam | Relationship | Period |
|---|---|---|---|
| ACCA | MA | Supporting | September 2026–June 2027 |
| FIA | FMA | Supporting | September 2026–June 2027 |