I just posted this formula for a similar type question. With a similar
formula, how about this?

=CHOOSE(LOOKUP(A1,{0,1;8501,2;21000,3;50001,4}),40 ,A1*4.75/1000,A1*5.25/1000,A1*5.25/1000)

I think these are the calculations you want. If not, I think you can follow
the pattern, otherwise, post back, and give sample expectations.
--
** John C **


"SM_NCSW" wrote:

I am trying to calculate a progressive rate for water use charges:
<8500=$40,
8501 up to /1000
21000 up to /1000
50000 @6.00/1000

Col.A lists consumtion in gallons
is there a formula I can use for this?