Description
Tests the condition and returns the specified value.
Syntax
IF ( condition, true_value, false_value )
| Parameter | 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. |
Examples
This function returns Greater if the contents of S1 is greater than 10 and Less if the contents of S1 is less than 10:
IF(S1>10, "Greater", "Less")
See also