Logical Functions

Article summary

Did you find this summary helpful?

Thank you for your feedback

Basic comparison operators: < > <= >= <>
IF([expression ], TrueResult , FalseResult ), evaluates the logic of the expressions and returns TrueResult if the expression is true and FalseResult if the expression is false.
AND([expression1 ], [expression2 ]), returns TRUE if expression1 and expression2 are both true, otherwise returns FALSE.
OR([expression1 ], [expressions2 ]), returns TRUE if either expression1 or expression2 is true; returns FALSE if both expressions are false.
ISBLANK([field ]), returns TRUE if the field is blank, otherwise returns FALSE.
Nested IF, you may nest IF functions within other IF functions. You can nest up to 7 levels.

Was this article helpful?