Using Boolean Expressions to Compare Values in Excel
To construct a Boolean expression, such as when you filter criteria, use a comparison operator and then a value used in the comparison: (>5, for example). These are Boolean comparisons that compare two values and evaluate whether the statement is true or false.
|Comparison Operator||What It Means|
|>=||Greater than or equal to|
|<=||Less than or equal to|
|<>||Not equal to|