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.

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.

The IF function is probably one of the most well-known formulas for Excel, as it allows for data points to be compared between a value and what you are expecting. IF statements are powerful because ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

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

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.

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

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.

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.