1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel IF Function Step by Step Tutorial

By , About.com Guide

6 of 8

Adding the "Value if True" Argument to the IF Function

Entering the "Value if True" Argument for the Excel IF Function

Entering the "Value if True" Argument

© Ted French

Adding the "Value if True" argument to the IF Function

Following our comma separator, we add in the “value if true” argument of the IF function followed by another comma separator.

In this case, if the value in cell A3 is greater than the value in cell B3, we want the function to place a "A is larger" in cell D1.

For our tutorial

type "A is larger" followed by a second comma ","

In cell D1 you should see:

=IF(A3 > B3,"A is larger",
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. IF Functions
  6. Excel IF Function - How to Create an IF Function in Excel - Adding the "Value if True" Result

©2009 About.com, a part of The New York Times Company.

All rights reserved.