Excel AND function | Exceljet
exceljet.net › functions › and-functionThe AND function will evaluate all values supplied and return TRUE only if all values evaluate to TRUE. If any value evaluates to FALSE, the AND function will return FALSE. Note: Excel will evaluate any number except zero (0) as TRUE. Both the AND function and the OR function will aggregate results to a single value. This means they can't be used in array operations that need to deliver an array of results.