On Sun, 10 Aug 2008 20:22:01 -0700, Siper1
wrote:

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

This seems to be the "standard" tax bracket problem.

Set up a table with three columns as follows:

Units Base Price
- 0 $1.00
50,000 $50,000.00 $0.75
150,000 $125,000.00 $0.50

I NAME'd it 'tbl'.

Then, with your "units" in A1, use this formula:

=(A1-VLOOKUP(A1,Tbl,1))*VLOOKUP(A1,Tbl,3)+VLOOKUP(A1,Tb l,2)
--ron