Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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)

...