The AND function returns TRUE only if all values in the array are TRUE.
In all other cases, AND will return FALSE.
Case-sensitive option
The formula above is not case-sensitive.
Like the formula above, this is anarray formulaand must be entered with control + shift + enter.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
