Excel IF Function Tutorials
The IF function is one of Excel’s most useful and most used functions. What it does is test to see whether a given condition is true or false. Depending upon the result, different outcomes for the function can be specified. The IF function has also been combined with other popular Excel functions to create such functions as SUMIF, COUNTIF, and AVERAGEIF. The tutorials below include step by step examples of using the IF function in Excel.
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. This tutorial includes a step by step example of how to use Excel's IF function.
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. This step by step tutorial walks you shows you how to use a nested IF function in Excel.
IF Function Format Tutorial Part 1
This tutorial covers basic formatting options in Excel. The tutorial is a continuation of the step by step IF function tutorial listed above and applies formatting techniques - such as adding rows, widening columns, and applying number formatting to the worksheet data.
IF Function Format Tutorial Part 2
This is part 2 of a tutorial covering basic formatting options in Excel. The tutorial uses the worksheet started in the step by step IF function tutorial listed above and applies formatting techniques - such as shading alternate rows of data, using merge and center for the worksheet title, and using the fill handle to copy formulas to other rows...
Excel SUMIF Function Step by Step Tutorial
The SUMIF function combines the IF function and SUM function in Excel. This combination allows you to add up those values in a selected range of data that meets specific criterion.
SUMIF looks for the specific criterion in one cell or field in the record and, if it finds a match, it adds that data or data in another specified field in the same...
Excel COUNTIF Function Step by Step Tutorial
The COUNTIF function combines the IF function and COUNT function in Excel. This combination allows you to count the number of times specific data is found in a selected group of cells.
The IF portion of the function determines what data meets the specified criteria and the COUNT part does the counting.
Excel AVERAGEIF Function Step by Step Tutorial
The AVERAGE IF function combines the IF function and AVERAGE function in Excel. This combination allows you to find the average or arithmetic mean of those values in a selected range of data that meets specific criteria.
Excel SUMIFS Function Step by Step Tutorial
The SUMIFS function extends the usefulness of the SUMIF function by allowing you to specify from 2 to 127 criteria rather than just one as in SUMIF.
Excel COUNTIFS Function Step by Step Tutorial
Excel's COUNTIFS function can be used to count up the number of data records in a selected range that match specific criteria.
COUNTIFS extends the usefulness of the COUNTIF function by allowing you to specify from 2 to 127 criteria rather than just one as in COUNTIF.
Excel AVERAGEIFS Function Step by Step Tutorial
The AVERAGEIFS function extends the usefulness of the AVERAGEIF function by allowing you to set conditions on two or more ranges of data rather than just one as in AVERAGEIF.