• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

No wonder Chandoo wrote a book on lookup table function !!!

arishy

Member
Here is my problem:
Calculate electricity bill
The progressive table
0001-0050 costs 0.05
0051-0200 costs 0.10
0201-0350 costs 0.15
0351-0650 costs 0.25
0651-1000 costs 0.40
1001 plus costs 0.50

I need to add accumulative costs to reach the final cost, in this table 1500 KWH cost 505.00

The question is : VBA or a very complicated vlookup ???
 
Back
Top