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.

Figure A How to use XLOOKUP () to calculate commissions in Excel Let’s review the commission requirements using real data this time. The first sale value is $1,208.

How to calculate return on investment (ROI), the money an investment made relative to its cost, in Microsoft Excel.