A1 is how many gallons
therefore, yoru formula would be
=A1*LOOKUP(A1,{0,?;5000,1;15000,1.5;25000,1.75})
The ? is because what happens if the it is under 5000 gallons? I understand
the argument of "well, that's never happened", but still, like to be
prepared. If the rate is still 1, then you could change the part between the
curly-cue brackets thusly
{0,1;15000,1.5;25000,1.75}

--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"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