Logical functions

If

Tests a condition (the first argument) and returns the second argument if the condition is true. Otherwise the third argument is returned.
Example: IF(2 < 3, 1, 2)

And

Returns true if all of the supplied arguments are true. Numeric values that differs from 0 will be read as true.
Example: AND(true, 1)

Not

Returns true if the supplied argument is false. A numeric value of 0 will be read as false.
Example: NOT(false)

Or

Returns true if one or more of the supplied arguments are true. Numeric values that differs from 0 will be read as true.
Example: OR(true, false, false, 0, 1)

---

Home