How can I calculate commissions with excel?

[dinara]

Hi, there is a new function in finaquant's add-in for table functions: Commission Calculation

I don't understand how to use it, which inputs to select.. There is no explanation in the manual. Thanks for any help.

[finaquant]

You may find detailed information in our new article at finaquant.com:
Calculating Sales Commissions in Excel

There is also a 2.5-minute video showing all the steps below for commission calculation:

1. Download and install our Excel Add-in (Finaquant in Excel) for Table Valued Functions.
   
2. Run Create Test Tables to generate all the four input tables required for commission calculation
   
3. Run Calculate Sales Commissions after selecting and entering proper parameters into the parameter form in Excel.