#1
|
|||
|
|||
I really need help
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 |
#2
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|