The Logical Test
There a number of comparison operators that can be used in Excel's IF function logical test argument. 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 ( < > )
Examples
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
