Hi



I really need help making a formula in 1 line to calculate water bill based on customer class, usage volume with progressive rates.

The table is like this:


Excel Forum 2.jpg

As an example :

Usage volume is 100 M3
Customer class is Rumah Tangga I
the bill is 276,250 with the following details:

1-10 m3 : 10 x 1,500 = 15,000
11-15 : 5 x 1.850 = 9.250
16-20 : 5 x 2,400 = 12,000
> 20 : 80 x 3,000 = 240,000

GRAND TOTAL = 276,250

How to make a formula in 1 line to calculate the water bill ?
Thank you for the help