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

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 >>

 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.