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

[arishy]

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 ???

 

[NARAYANK991]

Hi ,

See if this is acceptable.

Narayan

 

[arishy]

Hi ,

See if this is acceptable.

Narayan

Narayan,
You took me back to the future....
What a master piece....
Many thanks