You are here:About>Computing & Technology>Spreadsheets> Functions in Excel> IF Functions> Excel IF Function - How to Create an IF Function in Excel -  Adding the "Value if True" Result
About.comSpreadsheets
Newsletters & RSSEmail to a friendSubmit to Digg
Free Excel Tutorial Series

Beginner's Guide to ExcelBasic Calculations in Excel SpreadsheetsHow to Format Excel Spreadsheets

Excel for Beginners

Entering Data in ExcelBasic Formatting in ExcelHow to Use Excel Spreadsheet Formulas

Free Excel Tutorials

What is Excel?Excel IF FunctionsExcel Tips

Excel IF Function Step by Step Tutorial

From Ted French,
Your Guide to Spreadsheets.
FREE Newsletter. Sign Up Now!

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",
  1. The IF Function - Step by Step
  2. Enter the Data for the IF Function
  3. Starting the IF Function
  4. Parts of the IF Function
  5. Writing the IF Function Logic Test
  6. Adding the "Value if True" Argument to the IF Function
  7. Adding the "Value if False" Argument to the IF Function
  8. Copying the IF Function to Other Cells

<< Previous | Next >>
Las Vegas on a Budget

Find a BargainHotel DealsCheap EatsFree AttractionsEntertainment for Less

 All Topics | Email Article | | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.