Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel IF Functions

The IF function is one of Excel’s most useful and most used functions. What it does, basically, is test to see whether a certain condition is true or false. These articles cover creating and using the IF function in Excel spreadsheets and give examples of how this versatile can be utilized.
The Excel IF Function - Step by Step Tutorial
The Excel IF function is one of the most useful functions available in the program. Once you understand how the IF function works you will find many reasons to use it. The IF function allows for decision making in a spreadsheet. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met.
Excel 2007 IF Function
The IF function is one of Excel’s most useful and most used functions. What it does, basically, is test to see whether a certain condition is true or false. This articles cover creating and using the IF function in Excel spreadsheets.
Nested IF Functions in Excel
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. To increase the flexibility of the function, we can create nested IF functions. A nested IF function is located inside another another IF function. This article covers creating nested IF functions in Excel.
Performing Calculations with the IF Function
One option for using the 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.
Using the IF Function to Enter Data
The IF function is one of Excel’s most useful functions. One 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.
Using the IF Function to Enter Text
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. One option for using the IF function is to have it enter different words 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.
Leaving Blank Cells When Using the IF Function
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. One option for using the IF function is to have it leave cells blank, depending on whether the tested condition is true or false. This article covers leaving cells blank when using the IF function.
IF Function Comparison Operators
The 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.

Explore Spreadsheets

About.com Special Features

Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. IF Functions

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

All rights reserved.