Table of Contents

Formulas - Logical

Sofia Teran Updated by Sofia Teran

Logical

Formulas available:

  • And
  • If
  • Not
  • Or
Examples of use case of Logical formulas:

AND

Let's take a look on this example: if email contains "gmail.com" AND the age is over 18

And(Contains(@email,"gmail.com"),IsGreater(@age,18))

IF

Check if the age is above 18

If(IsGreater(@age,18),"Is greater","Is not greater")

Not

This formula is used to negate an expression and works with Boolean data type that has one of two possible values, which can be True/False or 0/1.

Not(0)

OR

In this example we want to know if the selected city is Barcelona OR Madrid:

Or(IsEqual(@city, "Barcelona"),IsEqual(@city,"Madrid"))

How did we do?

Formulas - Array

Formulas - Object

Contact