Excel IF Functions

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. This tutorial includes a step by step example of how to use Excel's IF function.

A Nested IF function in Excel allow you to test for multiple conditions in your data and assign different actions depending upon the results. This step by step tutorial walks you shows you how to use a nested IF function in Excel.

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

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 tutorial gives a quick overview of creating and using the IF function in Excel spreadsheets.

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.

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.

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.

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

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.

The AVERAGE IF function finds the average value for a range of cells - but only if those values meet specific criteria. This tutorial includes a step by step example of using Excel's AVERAGE IF function.

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's COUNTIF function is used to count up the number of times specific data is found in a selected group of cells. This tutorial includes a step by step example of using the COUNTIF function in Excel.

The AVERAGEIFS function finds the average value for a range of cells - but only if those values meet the criteria that you set. This tutorial includes a step by step example of using Excel's AVERAGEIFS function.

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's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

The AVERAGE IF function is used to find the average of values in cells that meet certain criteria. This tutorial contains a step by step example of using the AVERAGEIF function in Excel.

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.

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.

The SUMIFS function, similar to Excel's SUMIF function, is used to add up the contents of cells in a selected range that meet multiple criterion. This article includes an example of using the SUMIFS function in Excel 2010.

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.

The AVERAGEIFS function finds the average value for a range of cells - but only if those values meet the criteria that you set. This tutorial includes a step by step example of using Excel's AVERAGEIFS function.

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.

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.

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.