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.

The key to calculating a conditional running total is discerning the condition and then expressing that condition in a way that Excel can interpret. In this case, the condition is the month.

Open an Excel workbook and select Conditional Formatting > New Rule. Select Format only cells that contain . Select Cell ...

To solve this problem, Excel allows conditional calculations so that you can calculate the normal rate for up to 40 hours worked and then a higher amount for overtime hours worked. Open a new ...

Excel's checkboxes are a deceptively simple tool that can ... For instance, if C2 is TRUE, B2 should be included in the calculation, ... Pair them with formulas and conditional ...