1Equal to = = A1 = B1 The formula returns TRUE if a value in cell A1 is equal to the values in cell B1; FALSE otherwise.
2Not equal to <> = A1 <> B1 The formula returns TRUE if a value in cell A1 is not equal to the value in cell B1; FALSE otherwise.
3Greater than > = A1 > B1 The formula returns TRUE if a value in cell A1 is greater than a value in cell B1; otherwise it returns FALSE.
4Less than < = A1 < B1 The formula returns TRUE if a value in cell A1 is less than in cell B1; FALSE otherwise.
5Greater than or equal to >= = A1 >= B1 The formula returns TRUE if a value in cell A1 is greater than or equal to the values in cell B1; FALSE otherwise.
6Less than or equal to <= = A1 <= B1 The formula returns TRUE if a value in cell A1 is less than or equal to the values in cell B1; FALSE otherwise.
1<> Not equal. Note: In some versions of SQL this operator may be written as !=
2
3Example sql query:
4
51) Selecting groceries where price is not 20
6SELECT * FROM Grocery WHERE Price <> 20;