AND (Report Builder)
Returns TRUE if all arguments are TRUE; returns FALSE if one or more arguments are FALSE.
Syntax
AND(logical1, logical2)
Logical1 |
Indicates the first condition to be tested. |
Logical2 |
Indicates the second condition to be tested, if the first condition is True. |
Remarks
- The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays or references that contain logical values.
- If an array or reference argument contains empty cells, those values are ignored.
Example
| Formula | Result |
|---|---|
AND(Online Order Flag = "True", Total Due > 50) |
Returns a True value for every item that was ordered online and the total due is more than $50.00. If the total due value is more than $50 but it was not purchased online, then the value is False. If the total due is less than $50 but the item was purchased online, then the value is False. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Logical Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)