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
Last updated