I am having trouble wrapping my brain around this one:

I want to create some sales scenarios using scales , eg

You get 3% of sales for the first 1000 widgets
you get 2% for the next 3000 widgets
you get 1% for all widgets sold in excess of 4000

Of course I want the numbers to be 'knobs' so I can tune my scenario into
something that works.

I see it being pretty ugly using formulas

Is there an easy or elegant way to do this?



Thanks

Bill