AND (Report Builder 1.0)
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. |