Beginner
Logical
IF
Returns one value if a condition is true, and another if it's false.
Compatibility: All Excel versions
Syntax
=IF(logical_test, value_if_true, value_if_false)
Example
=IF(A1>=60,"Pass","Fail")
When to Use It
Use IF any time a result should depend on a condition — pass/fail, in-stock/out-of-stock, over-budget/under-budget.