1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel IF Function Step by Step Tutorial

By , About.com Guide

7 of 8

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

The Completed Excel IF Function

The Completed IF Function

© Ted French

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

The last section to add to the IF function is the “value if false" argument of the function followed by the right or closing round bracket.

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

For our example

type "B is larger" followed by a right or closing round bracket ")".

In cell D1 you should see the completed IF function:

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

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

Easy ways to connect two computers for networking purposes. 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" Argument

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

All rights reserved.