=IF(A1<0,"",IF(A1<8501,40,IF(A1<21000,A1*4.75/1000,IF(A1<50001,A1*5.25/1000,A1*6/1000))))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"SM_NCSW" wrote in message
...
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?