The formula returns TRUE because the value in cell A1 is greater than or equal to the value in cell B1. Entering the formula with SUMIF and Greater Than Function Interpretation of formula. As shown below the number of students with scores greater than 90 are highlighted in orange.
If you need to include the boundary values 50 and 100 use the less than or equal to operator operator.
Both operators will return FALSE if the values are equal. For example the greater than or equal to Excel operator is written as and the greater than operator is written as. If you need to include the boundary values 50 and 100 use the less than or equal to operator operator. As shown below the number of students with scores greater than 90 are highlighted in orange.