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

Cross posted and solved Tiered pricing [SOLVED]
and at Tiered Pricing | MrExcel Message Board



Please read Excelguru Help Site - A message to forum cross posters

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post