1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

IF Function Comparison Operators

Operators Used in the IF Function's Logical Test Argument

By

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 ( < > )

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.