Forum Discussion
calculating water rates on a per thousand/tier
I am trying to calculate a water table that I could change the rates in B12-B23 in order to get a monthly bill about for water consumption. I have found several issues. Even if 0 qty is used ther...
Hi Alexzandra,
If you define your ranges like this
the formula could be
=MAX(B12*LOOKUP(B12,$F$3:$F$8,$G$3:$G$8)+LOOKUP(B12,$F$3:$F$8,$H$3:$H$8),$G$3)
and attached