IF
Checks the value of an expression and returns a specified value if the expression is true, and returns a different value if not.
Syntax
=IF(expr, resultTrue, resultFalse)
Arguments
| Argument | Type | Description |
|---|---|---|
| expr | Boolean | The expression to evaluate when determining which value to return |
| resultTrue | Any | The value to return if the expression evaluates to true |
| resultFalse | Any | The value to return if the expression evaluates to false |
Examples
=IF(10 < 20, "Yes", "No") → "Yes"
Checks if 10 is less than 20 and returns "Yes" if so, and "No" otherwise. Because 10 is less than 20, "Yes" is returned.
=IF(10 > 20, "Yes", "No") → "No"
Checks if 10 is greater than 20 and returns "Yes" if so, and "No" otherwise. Because 10 is not greater than 20, "No" is returned.
=IF(@"Property 1" = 1, "A", "B") → "A"
Checks if the shape data property "Property 1" is equal to 1 and returns "A" if so, and "B" otherwise. Because "Property 1" is equal to 1, the function returns "A".
Updated 10 months ago