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 running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.