IF
LogicalIF helps you perform conditional and boolean logic helpers for branching worksheet behavior.
Overview
Start with "=" then enter IF(condition, value_if_true, [value_if_false]). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=IF(condition, value_if_true, [value_if_false])
2 to 3 arguments
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| condition | Required | Single | Input argument used by this function. |
| value_if_true | Required | Single | Input argument used by this function. |
| value_if_false | Optional | Single | Optional argument for advanced control. |
Example Inputs & Outputs
Formula
=IF(A1>0,"Pass","Fail")
Example Output
Pass
Returns one value if the condition is true and another if false.