Conditional Expressions for Formulas

Updated 2 years ago by dustin keir

You can create conditional expressions in your formula user-defined fields. Conditional expressions use the If expression to evaluate comparison statements and return values based on the results of the statements.

Conditional expressions use the following syntax:

If (Comparison Statement, True Value, False Value)

Comparison Statement – Uses comparison operators to compare two values. Comparison statements can use the following operators:

  • == to check that two values are equal to each other.

  • != to check that two values are not equal to each other.

  • > to check that the first value is greater than the second value.

  • < to check that the first value is less than the second value.

  • >= to check that the first value is greater than or equal to the second value.

  • <= to check that the first value is less than or equal to the second value.

Comparison statements can be combined with logical operators:

  • Or – Combines two comparison statements where either one of the statements is true.

  • And – Combines two comparison statements where both of the statements is true.

  • Not – Negates a comparison statement.

  • True Value – The value of the expression when the comparison statement is true. It can also be combined with other expressions.

  • False Value – The value of the expression when the comparison statement is false. You can include other conditional statements to supply different answers for different values.


How did we do?