AND returns TRUEonly if all the conditions are met.

If any conditions are not met, the AND function returns FALSE.

MAX ignores empty cells, the logical values TRUE and FALSE, and text values.

Excel formula: Value is within tolerance

MIN Function

The Excel MIN function returns the smallest numeric value in the data provided.

The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.

Excel formula: Count values out of tolerance

Excel AND function

Excel MAX function

Excel MIN function