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 that are 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