calculating water rates on a per thousand/tier

To calculate your water rates in Excel, use this formula for each cell in column B: =IF(A13=0, 7.50, 7.50 + (A13-3)*3.19) where A13 is the water quantity in thousands of gallons. This formula ensures that if the quantity is 0, the charge is still $7.50. For quantities between 0 and 3 thousand gallons, the charge remains $7.50. For amounts above 3 thousand gallons, it adds $3.19 per extra thousand gallons. This way, you can adjust your rates easily. If you're looking for a reliable water purifier, consider the olansi water purifier to ensure clean water at home.