| You are here: | About>Computing & Technology>Spreadsheets> Functions in Excel> Excel IF Functions - How to Use Excel IF Functions - Excel IF Functions |
![]() | Spreadsheets |
![]() Using the Excel IF Function © Ted French More Free Excel TutorialsFreeze Panes in ExcelHow to Create Data Tables and Lists in ExcelPrinting Options in Excel Excel IF FunctionsUsing IF Functions in Excel SpreadsheetsIF functions are one of the most versatile functions available in Excel and other spreadsheet programs. This Series of Articles covers how to use Excel IF functions as well as uses for the IF function in spreadsheets.
1) How to Use IF Functions in ExcelOne of the most useful functions in Excel is the IF function. What this function does is test a value in a specific cell to see if that value meets a certain condition. If it does, one result will happen, if not, a different action can occur. This article covers how to write an Excel IF function.
2) IF Functions - Step by Step TutorialNew to the IF function? If so, and if you would like a walk through on building this valuable function one step at a time, than this tutorial is for you. Just like the title says, we build the IF function step by step - with explanations and examples included to help you out.
3) Excel 2007 IF FunctionThis article walks you through an example of using the IF function in the latest version of Excel.
4) Nested IF Functions in ExcelTo increase the flexibility of the IF function, we can "nest" or place one IF function inside another IF Function. This article covers creating nested IF functions in Excel.
5) Performing Calculations with the IF FunctionA second option for using the Excel IF function is to have it carry out different calculations, depending on whether the tested condition is true or false. This article covers using the IF function to perform calculations on spreadsheet data.
6) Using the IF Function to Enter DataA third option when using the IF function is to have it enter one of two values into a target cell, depending on whether the tested condition is true or false. This article covers using the IF function to enter data into a spreadsheet.
7) Using the IF Function to Enter TextA fourth option when using the IF function is to have it enter different words or statements into a cell, depending on whether the tested condition is true or false. This article covers using the IF function to entering text into a spreadsheet.
8) Leaving Blank Cells When Using the IF FunctionA fifth option for using the Excel IF function is to have it leave a cell blank, depending on whether the tested condition is true or false. This article covers leaving a cell blank when using the IF function.
9) Logic Function Comparison OperatorsThe logic test section of an Excel IF function is always a comparison between two values. To accomplish this, a comparison operator, such as the greater than symbol ( > ), is always placed between the two amounts being compared. This article is a handy list of the different comparison operators that can be used in Excel IF functions.More Free Excel TutorialsFreeze Panes in ExcelHow to Create Data Tables and Lists in ExcelPrinting Options in Excel |
Las Vegas on a BudgetFind a BargainHotel DealsCheap EatsFree AttractionsEntertainment for Less |
All Topics | Email Article | | | ![]() |
| Advertising Info | News & Events | Work at About | SiteMap | Reprints | Help | Our 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. |



