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.