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

Excel IF Function Step by Step Tutorial

By

8 of 8

Comparison Operators Used in the IF Function

Comparison Operators Used in the IF Function

The comparison operators that can be used in the logical test of an Excel IF function are:

Equals ( =)

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Instructions for completing the formatting for this tutorial are available in a separate tutorial entitled Excel Format Tutorial Part 1.

©2014 About.com. All rights reserved.