Explanation
At the core, this formula uses the COUNTIF function to count any cells that fall below a given value, which is hardcoded as 65 in the formula:
COUNTIF(B5:F5,"<65")
In this part of the formula, COUNTIF will return a positive number if any cell in the range is less than 65, and zero if not. In the range B5:F5, there is one score below 65 so COUNTIF will return 1.
The NOT function is used to convert the number of from COUNTIF into a TRUE or FALSE result. The trick is that NOT also "flips" the result at the same time:
- If any values are less than 65, COUNTIF returns a positive number and NOT returns FALSE
- f no values are less than 65, COUNTIF returns a zero and NOT returns TRUE
This is the equivalent of wrapping COUNTIF inside IF and providing a "reversed" TRUE and FALSE result like this:
=IF(COUNTIF(B5:F5,"<65"),FALSE,TRUE)
Related formulas
All cells in range are blank
Related functions
COUNTIF Function
The Excel COUNTIF function returns the count of cells in a range that meet a single condition. The generic syntax is COUNTIF(range, criteria), where "range" contains the cells to count, and "criteria" is a condition that must be true for a cell to be counted. COUNTIF can be used to count cells...
NOT Function
The Excel NOT function returns the opposite of a given logical or Boolean value. When given TRUE, NOT returns FALSE. When given FALSE, NOT returns TRUE. Use the NOT function to reverse a logical value.
