Use this function to check if a condition is met.
| Syntax | Description | Example |
|---|---|---|
| If(Condition(s), IsTrue[Otherwise]) | Returns one value if a condition is true and another value if not. |  |
Arguments
For more information on arguments, see the table below.
| Argument | Type | Description |
|---|---|---|
Condition(s) | Required | Conditions/Expressions to test for true. |
IsTrue | Required | The value to use if the condition evaluates to true. |
Otherwise | Optional | The value to use if the condition(s) do not evaluate to true. If nothing is specified then nothing is returned. |
Examples
If(true, “Apricot”, “Blackberry”): ApricotIf(false, “Apricot”, “Blackberry”): BlackberryIf(1 > 0, “Apricot”, “Blackberry”): ApricotIf(1 < 0, “Apricot”, “Blackberry”): BlackberryIf(true && 1 > 0, “Apricot”, “Blackberry”): ApricotIf(true, If(1 > 0, “Apricot”, “Blackberry”), "Raspberry"): ApricotIf(false, If(1 > 0, “Apricot”, “Blackberry”), "Raspberry"): Raspberry
Updated 11 months ago