I REALLY NEED HELP

[densoes]

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:

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

 

[Peter_SSs]

Duplicate to: Index, Match and Array

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.