See if this page from J.E.'s web site helps.

It's not a template, but should give you some insight in how to structure
the formulas.

http://www.mcgimpsey.com/excel/variablerate.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Alvin McNair" <Alvin wrote in message
...
I'm in need of a sales commission tracker for a tier commission sales
plan.
I'd like it to segregate payment timings as well.