if
if(condition,trueclause,falseclause)
The IF function has the following arguments:
conditionThe condition to be evaluated.
trueclauseThe clause to be evaluated and returned if the condition is true.
falseclauseThe clause to be evaluated and returned if the condition is false.
First evaluate the condition clause, and if the result is true then evaluate and return the true clause. Otherwise evaluate and return the false clause.
The true clause and false clause must return the same data types.
|
Formula |
Description |
Result |
|---|---|---|
|
if(10 < 100, 'a', 'b') | Test the condition and then evaluate and return the appropriate clause. | 'a' |
| if(100 < 10, 'a', if('a' = lower('A'), 'b', 'c')) | An example of a nested if statement |
'b' |