1. Computing

Excel IF Function Step by Step Tutorial

By

4 of 8

Parts of the IF Function
The Three Parts to the Excel 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.

©2014 About.com. All rights reserved.