AND

Use the AND function to determine if all conditions in a test are TRUE.

Use

AND( condition1, [condition2], ... )
Returns TRUE if all logical conditions are TRUE.

Parameter	Required	Description
condition1	Yes	the initial condition to test, which must result in either TRUE or FALSE
condition2, ...	No	additional conditions to test, which must result in either TRUE or FALSE

Returns

Logical

Use with literals

AND(TRUE, TRUE)

returns TRUE

AND(TRUE, FALSE, TRUE)

returns FALSE

Use with fields

AND(#Report, $Available)

returns TRUE when constant field #Report is TRUE and variable field $Available is TRUE, otherwise returns FALSE

Use with expressions

AND($Amount > 0, EXACT(@inp.Name, "Fred"))

if variable field $Amount is positive and input field @inp.Name is "Fred" , returns TRUE, otherwise returns FALSE