Description Tests the condition and returns the specified value.
Syntax IF ( condition, true_value, false_value )
| Argument | Description |
|---|---|
| condition | Any logical expression. |
| true_value | The value to be returned if condition evaluates to True. |
| false_value | The value to be returned if condition evaluates to False. |
Example This function returns Greater if the contents of A1 is greater than 10 and Less if the contents of A1 is less than 10:
IF(A1>10, "Greater", "Less")
See Also AND, FALSE, NOT, OR, TRUE
