AND
The AND function returns TRUE if all the conditions are TRUE and FALSE if any of the conditions are FALSE.
Syntax
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
Returns 25 if the region is West and the category is 'Urban'; otherwise returns 30
Excel equivalent
Last updated