Does anyone know how to set up a macro that can calculate commisions based on a tiered system. For example, between $0 and $10, the rate is .02, between $10.01 and $20, the rate is .06, over $20.01 - the rate is .0675.
I have a spread sheet that calculates my sales on a monthly basis and applies a flat % for commissions but i never took into account the highier rates for over quota. The spreadsheet works great except for calculating accelerators that kick in once you achieve certain threshholds.
Thanks in advance!!
Bookmarks