AND

The AND function returns TRUE if all the conditions are TRUE and FALSE if any of the conditions are FALSE.

Syntax

and( logical_test1, [logical_test2], ... )

Arguments

logical_test1 – The first condition to be evaluated. This is a required argument.

logical_test2,.. – The additional conditions to be evaluated. These are optional arguments.

Return value

Either True or False

Example

if(and(Region == "West", Category=="Urban"), 25, 30)

Returns 25 if the region is West and the category is Urban, otherwise returns 30

Excel equivalent

AND