I need some help on a formula for calculating customers bills for water usage. The rate structure is graduated and is beyond my abilities. Basically I have a spreadsheet where customers account information including their usage (in gallons) for a given month in Column F. The rate structure is as follows:
$11.50 min Includes 2000 gallons
$2.52 per thousand for the next 3000 gallons
$2.12 per thousand for the next 5000 gallons
$1.37 per thousand for anything over 10000 gallons.
I would like to have all of the rates in a legend at the top so that I can experiment with different rates by simply entering them into that cell and be able to see the effects it would have on that months billing.
Thanks
$11.50 min Includes 2000 gallons
$2.52 per thousand for the next 3000 gallons
$2.12 per thousand for the next 5000 gallons
$1.37 per thousand for anything over 10000 gallons.
I would like to have all of the rates in a legend at the top so that I can experiment with different rates by simply entering them into that cell and be able to see the effects it would have on that months billing.
Thanks