Functions
AND
| Syntax |
(expression1) AND (expression2) |
| Description |
Returns true if both the expressions evaluate to true. |
| Example |
IF([CustomerID]='VINET' AND [OrderID]='10248', [Discount], [Discount]+0.1) |
NOT
| Syntax |
NOT(expression) |
| Description |
Returns the reversed logical value of the expression being evaluated. |
| Example |
IF(NOT [CustomerID]='VINET', [Freight], [Freight]-100) |
OR
| Syntax |
(expression1) OR (expression2) |
| Description |
Returns true if any of the expressions evaluate to true. |
| Example |
IF([CustomerID]='VINET' OR [OrderID]='10248', [Discount], [Discount]+0.1) |
Thank you for your feedback and comments.We will rectify this as soon as possible!