On Fri, 24 Oct 2008 11:34:04 -0700, 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?


That table should have been NAME'd RateTbl
--ron