Excel IF Function Step by Step Tutorial

Parts of the IF Function

The Three Parts to the IF Function

© Ted French

Parts of the Excel IF function

Inside the round brackets there are three parts or arguments to an IF Function.

The Arguments

1. the logic test - in this tutorial it is A3 > B3
2. the value if true - in this tutorial it is "A is larger"
3. the value if false - in this tutorial it is "B is larger"

Between each argument of the IF function, the comma is used as a separator. The comma is what tells Excel when each argument of IF function ends and the next section begins.

Adding Separators

Therefore, as we complete the IF function, we will add two separators

1. one between the logical test and the “value if true” arguments
2. one between the “value if true” and the “value if false” arguments.

• The IF Function - Step by Step
• Enter the Data for the IF Function
• Starting the IF Function
• Parts of the IF Function
• Writing the IF Function Logic Test
• Adding the "Value if True" Argument to the IF Function
• Adding the "Value if False" Argument to the IF Function
• Copying the IF Function to Other Cells