Tiered Pricing
 

Look at the VLOOKUP function in help then come back with more questions
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"steve" wrote in message
...
Hi everyone. I have a table like the one below that is basically a tiered
pricing schedule. Basically, each tier has its own price. So in the
example
below of a quantity of 17,500 (input cell), the first 1,000 is at a price
of
25.22, the the remaining 16,500 is at 26.00. Is there a way to formulate
this without doing tons of nested if statements? The number of tiers I
have
is much greater than what I pasted below! Thanks so much for your help!

-Steve

From To Price
0 1,000 $25.22
1,001 20,000 $26.00
20,001 60,000 $23.40
60,001 1,000,000,000 $21.06


# of Claims 17,500

Total $454,220.00