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 Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

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.