Agreed .. then how do I construct a worksheet for that?

"Rick Rothstein (MVP - VB)" wrote:

Repeating the same exact example that I said "I don't understand how you got
your numbers for it" will not make me understand it any more. My question to
you is HOW did you get those dollar figures from 250,000 units. It looks
like you divvied it up 50,000 to the first tier, 100,000 to the second tier
and 100,000 to the third tier. What I don't understand is why you didn't
divvy it up 50,000 to the first tier, 150,000 to the second tier and 50,000
to the third tier. What rule are you following that prevents you from using
150,000 of the 250,000 units for that second tier? And if for some reason
you can't use the 150,000, why aren't you using 149,999 then?

Rick


"Siper1" wrote in message
...
What I'm trying to do is set up a formula where I can put in the total
amount
of units used into 1 cell and then have the cost calculated based on
waterfall pricing.

Same example

250,000 Units

0-50,000 ($1) = $50,000
50,001 -150,000 ($.75) =$75,000
151,000+ ($.50) = $50,000

Total = $175,000



"Rick Rothstein (MVP - VB)" wrote:

Is your $250,000 unit example calculation correct??? I would have
expected
this

50000 = $50000
150000 = $112500
50000 = $25000
===== ======
250000 = $187500

If I am not correct, please explain in more detail how your price
schedule
is applied.

Rick


"Siper1" wrote in message
...
How can I calculate total pricing based on multiple priicing & usage
tiers
(IF Then or AND):

Usage - Price
0-50,000 = $1
50,001 - 150,000 = $.75
150,001+ = $.50

Example:

250,000 units

Need to automate the following:

50,000 = $50,000
50,001 - 150,000 = $75,000
150,001+ = $50,000

Total Due = $175,000