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