1. Computing

Excel IF Functions

Using IF Functions in Excel Spreadsheets

By

Using the Excel IF Function

Using the Excel IF Function

© Ted French

IF 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) Excel IF Function Step by Step Tutorial

The IF function introduces decision making into a spreadsheet. Depending on whether or not certain criteria are met, you can have the function place different results in one or more cells in the worksheet. This tutorial includes a step by step example with screen shots.

2) Excel IF Function - Text only Tutorial

This text - based tutorial gives you a quick walk through on using the IF function in Excel. It is intended for those experienced in using Excel's functions.

3) Excel Nested IF Function Step by Step Tutorial

Nesting an IF function involves placing one or more IF functions inside the first to increase the number of criteria that can be tested and increase the possible number of outcomes for the function. This tutorial includes a step by step example of using a nested IF function in Excel.

7) Nested IF Functions in Excel - Text only Tutorial

This text - based tutorial gives you a quick walk through on using nested IF functions in Excel. It is intended for those experienced in using nested functions in Excel.

8) Performing Calculations with the IF Function

A 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 tutorial covers using the IF function to perform calculations on spreadsheet data.

9) Using the IF Function to Enter Data

A 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 tutorial covers using the IF function to enter data into a spreadsheet.

10) Using the IF Function to Enter Text

A 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 tutorial covers using the IF function to entering text into a spreadsheet.

11) Leaving Blank Cells When Using the IF Function

A 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 tutorial covers leaving a cell blank when using the IF function.

12) Logic 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 tutorial is a handy list of the different comparison operators that can be used in Excel IF functions.

©2014 About.com. All rights reserved.