Syntax

IF(<Boolean>;<any>;<any>)

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.

Browser not supported