The Logical Test
There are six comparison operators that can be used in a spreadsheet's IF function logical test argument.
These operators are used to test for numerical equality - such as 7 = 7, and inequalities, such as 7 < > 3 or 2 < 12.The logical test can only return a true or false answer.
The Comparison Operators
The comparison operators that can be used in the logical test are:
Equals ( = )
Less than ( < )
Less than or equal to ( < = )
Greater than ( > )
Greater than or equal to ( > = )
Not equal to ( < > )
The logical test can be a comparison between two cell references such as:
A3 > B3
Or the logical test can be a comparison between a cell reference and a fixed amount such as:
C4 < = 100