Hi

I need to carry out an energy audit and would like to use a spreadsheet to
find costs

eg
1 - 2000 kWh = 0.20
2001 - 4000 kWh = 0.22
4001 - 6000 kWh = 0.24 and so on

so that when I get a figure of say 4200 and enter in the first column it
will show the first 2000 units at 0.20 in the next column then 2001 - 4000 at
0.22 in the next column and the remaining 200 units at 0.24 in the last
column. There are other limits to add but I could add as required providing I
get the basic idea???