...
Symbol | Logical Operations | Example |
|---|---|---|
| || | Or | IF(VoyageStatus=="Completed" || VoyageStatus=="Closed", ..., ...) |
| >= | Greater Than or Equal To | IF(CommenceDate >= TODAY(), ..., ...) |
| > | Greater Than | IF(CommenceDate > TODAY(), ..., ...) |
| == | Equality | IF(VoyageStatus=="Commenced", ..., ...) |
| <= | Less Than or Equal To | IF(CommenceDate <= TODAY(), ..., ...) |
| < | Less Than | IF(CommenceDate < TODAY(), ..., ...) |
| && | And | IF(VoyageStatus=="Commenced" && CommenceDate > TODAY(), ..., ...) |
| != | Inequality | IF(VoyageStatus!="Closed", ..., ...) |
| "" | Blank | IF(VoyageStatus!="", ..., ...) |
Boolean operations can be strung together to make complex conditions using parentheses (); for example:
...