Try this:

A1 = units = 250,000

=SUMPRODUCT(--(A1{0;50000;150000}),(A1-{0;50000;150000}),{0.6;-0.1;-0.1})

Probably better if you create a little table. That way it's easier to deal
with price changes/ level changes.

See this:

http://mcgimpsey.com/excel/variablerate.html


--
Biff
Microsoft Excel MVP


"Siper1" wrote in message
...
How can set up Excel to calculate total pricing based on multiple pricing
&
usage tiers:

Usage - Price
0-50,000 = $.60
50,001 - 150,000 = $.50
150,001+ = $.40

Example:

250,000 units

Need to automate the following:

50,000 = $30,000
50,001 - 150,000 = $50,000
150,001+ = $40,000

Total Due = $120,000