• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

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

### 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

Ted French