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