Does anyone know how to make a sliding scale? It is a commission sliding scale. The scale is 60% for 1st $100, 70% for 2nd $100, 75% for 3rd $100, 20% for 4th $100, 15% over $400.
If something sold for $580:
$60 of the 1st $100
$70 of the 2nd $100
$75 of the 3rd $100
$80 of the 4th $100
$153 of the Remainder after $400 ($180)
Total=$438
So basically I need to be able to punch in the Price then it would put the commission and the remainder into the next 2 cells.
Thanks
Daniel
Bookmarks