IF

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.

Column1Column2Column3Result
trueABA
falseABB
falseABB
trueABA
falseAnullnull
trueAnullA



You may also look at examples of how to use operators in workbook formulas in our Using Operators section.