IF
Specifies a logical test to perform.
LogicalBeginner EssentialsLogic & ConditionsMost Used
What it does
Returns one value if a condition is TRUE and another value if it is FALSE.
Syntax
IF(logical_test, value_if_true, [value_if_false])
Arguments
logical_test(logical) — Condition to test.value_if_true(value) — Returned when condition is TRUE.value_if_false(value) — Returned when condition is FALSE (optional).
Examples
Categorize scores
Return "High" if Score≥80 else "Low".
FORMULA
=IF(A2>=80,"High","Low")
RESULT
High
SAMPLE DATA
| A | |
|---|---|
| 1 | Score |
| 2 | 92 |
| 3 | 75 |
| 4 | 88 |
| 5 | 60 |