Share via

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.