John: With your formula on 64258 gallons, the result is $112.45, it should
be $93.50

Roger: With your formula on 64258 gallons, the result is $98.70, it should
be $93.50.

Any ideas on what the problem is?

"Rhomium" wrote:

Hello,

I'm trying to calculate water overage rates for my Town and could use some
help with a formula.

A cell contains the number 64258(gallons). For gallons between 5,000 and
15,000, the rate is $1 per 1,000 gallons (10*1), between 15,000 and 25,000
rate is $1.50 per 1000 gallons (10*1.50), and any over 25,000 rate is $1.75
per 1,000.

Anyone have any idea how to write the formula?

Thanks for any help.

JP