On Tue, 12 Aug 2008 07:31:01 -0700, Siper1
wrote:

Thanks for taking the time to teach me how to drive! .. sorry for being such
a neophite.


We were all neophytes at one time or another.

What did you eventually decide on?
--ron

My solution if the units sold are in A1 is the following array:

=SUMPRODUCT(--(A1{0,50000,500000}),A1-{0,50000,500000},{.5,-.1,-.05})


*** Sent via Developersdex http://www.developersdex.com ***

Well, I apologize. I mean, if your prices are still:
1-50000 = $1
50001-150000 = .75
150k+ = .5

...then the formula should read:

=SUMPRODUCT(--(A1{0,50000,500000}),A1-{0,50000,500000},{1,-.25,-.25})

Sorry for the error above. The last { } shows the differential as you go
through the tiers.
===============
"Actually, I *am* a rocket scientist."

*** Sent via Developersdex http://www.developersdex.com ***