1. Computing

IF Function Comparison Operators

Operators Used in the IF Function's Logical Test Argument

By

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

©2014 About.com. All rights reserved.