IF
- Juliane Wetzel
Owned by Juliane Wetzel
Syntax
Description
Checks first the arguments of a column to verify a Boolean data type. If the argument from the Boolean column is true the result is the argument from the column specified for true. If the argument for from the Boolean column is false the result is the argument from the column specified for false. The conditional argument must be Boolean and the result arguments must be the same data type.
Examples
=IF(#Column1;#Column2;#Column3)
If column1 is true the result is column2. If column1 is false the result is column3.
| Column1 | Column2 | Column3 | Result |
|---|---|---|---|
| true | A | B | A |
| false | A | B | B |
| false | A | B | B |
| true | A | B | A |
| false | A | null | null |
| true | A | null | A |
You may also look at examples of how to use operators in workbook formulas in our Using Operators section.