Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, and ...

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

Excel will calculate the number of days between the dates entered in cells B3 and A3 and display the result in cell C3. Take your mouse pointer to the lower-right corner of cell C3. It will turn ...

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

It’s not as complicated as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. Read on for tips on how to calculate age in Excel.

How to use Excel’s RANK.AVG() function. In almost every way, Excel’s RANK.AVG() function performs as RANK(), except in one way: RANK.AGE() returns an average rank if a number occurs more than ...

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

Excel 2010 includes a built-in function for computing the trimmed mean. Open a new Microsoft Excel 2010 spreadsheet. Click on cell "A1," and enter the first number in the data set you want to get ...

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.