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.

Launch Excel. Type "Investment Amount" in cell A1. Widen column A until it is slightly larger than the text in cell A1. Type "Money Gained from Investment" into cell B1.

Head back to your Excel worksheet and type =CalculateCommission(G11) and calculate commission in no time. As you can see, VBA offers a number of opportunities to tailor Excel functions to your needs.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.