The IF function is one of the most commonly used functions in Microsoft Excel. With it, you can test a value to see if it meets criteria. If it does, then display one result and if it doesn’t, then ...

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

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...