I did not really explain what I want to do with this so here goes;

using my algorithm below, I want to list commision dollars ofr various sales

so assuming each widget costs $1 then

Sales qty Commission
1000 1 x 1000 x 3% = 30
2000 ( 1 x 2000 x 3% = 60 + 1x 1000 x 2% = 20) = 80


Bill





"Bill" wrote in message
...
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