The available logical operators and functions are summarised in the table below.
Logical Operators and Functions
Function |
Description |
A < B |
Returns TRUE if A less than B |
A <= B |
Returns TRUE if A less than or equal to B |
A > B |
Returns TRUE if A greater than B |
A >= B |
Returns TRUE if A greater than or equal to B |
A = B |
Returns TRUE if A equals B |
AND(A, B) |
Returns TRUE if A and B are TRUE |
IF(A, B, C) |
If A is true, returns the value of B, else returns the value of C |
NOT(A) |
If A is TRUE, returns FALSE. If A is FALSE, returns TRUE/ |
OR(A, B) |
Returns TRUE if either A or B are TRUE |