# Excel IF Functions

The IF function is one of Excel’s most useful and most used functions. What it does is test to see whether a certain condition is true or false. These tutorials cover creating and using the IF function in Excel spreadsheets and give examples of how this versatile function can be utilized.

Excel IF Function Step by Step Tutorial
Excel’s IF function can be used to determine if a specified condition is true or false. The function will return different data depending on the answer.

Excel Nested IF Function Step by Step Tutorial
A Nested IF function in Excel allow you to test for multiple conditions in your data and assign different actions depending upon the results.

Excel IF Function - Text only Version
This bare bones version of the IF function tutorial above is intended for those who are familiar with using Excel functions is one of Excel’s most useful and most used functions.

Excel 2003 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...

Nested IF Functions in Excel Quick Tuttorial
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...

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.

Excel SUMIF Function Step by Step Tutorial
The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial includes a step by step example of using the SUMIF function in Excel.

Excel SUMIFS Function Step by Step Tutorial
Excel's SUMIFS function adds up the data in selected cells when specific criteria are met in two or more ranges of data. A step by step example of using the SUMIFS function is included.

Excel COUNTIFS Function Step by Step Tutorial
Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria.

Excel COUNTIF Function Quick Tutorial
Excel's COUNTIF function is used to count up the number of cells in a selected range that meet specified criteria. This tutorial includes a step by step example of using the COUNTIF function in Excel 2010.

Excel SUMIF Function Quick Tutorial
The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIF function in Excel 2010.

Excel COUNTIFS Function Quick Tutorial
The COUNTIFS function, similar to Excel's COUNTIF function, is used to count up the number of cells in selected ranges that meet multiple criterion. This tutorial contains a step by step example of using COUNTIFS in Excel.

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.

Data for the Excel 2007 / 2010 IF Function Step by Step Tutorial
This document contains the tutorial data for the Excel 2007 IF Function Step by Step Tutorial. The data is to be copied and pasted into the tutorial worksheet.

Data for the Excel Nested IF Function Step by Step Tutorial
This document contains the tutorial data for the Excel 2007 IF Function Step by Step Tutorial. The data is to be copied and pasted into the tutorial worksheet.

Excel COUNTIF Function Step by Step Tutorial
Excel's COUNTIF function is used to count the number of data records in a selected range that meet a single criteria.

Discuss in my forum