Calculate your sales commissions in Google Sheets using this easy formula (XLOOKUP). This step-by-step tutorial will walk you through how to set everything up so that you can automate your commission calculations in Google Sheets. This method also works for Excel, so you can set this up in whichever spreadsheet platform you like the most.

Don't forget to subscribe to our channel for more great content!    / @customexcelspreadsheets  

Also, check out our Commissions playlist for more great tips & tutorials:    • Sales & Commissions  

If you need help with a spreadsheet or have comments/questions, let me know in the comments below!