Excel IF Function Step by Step Tutorial

By Ted French, About.com Guide

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.

Return to Index page

Previous

• How the IF Function Works
• Entering the Tutorial Data
• Starting the IF Function
• Entering the Logical Test Argument
• Entering the Value If True Argument
• Entering the Value If False Argument
• Copying the IF function using the Fill Handle
• Comparison Operators Used in the IF Function

Next