Electricity Acc. Formula

country rose

New Member
Joined
Mar 22, 2014
Messages
28
Hi Guys

I have an electricity invoice which I would like to set up - the invoice is as follows :


No of days = 31days
Prev. Reading = 99966 Current Reading = 101418 Difference(Consumption) = 1452


Network charge @ 3.52 p/day for 31days = 109.12
Energy charge(0-600kwh) 600kwh @ 0.8208 = 492.48
Energy charge(> 600kwh) 852kwh @ 1.296 = 1 104.19
Sub Total 1 705.79
Vat at 14% 238.81
Total 1 944.60


The tricky part is Energy charge(0-600kwh) 600kwh @ 0.8208 as if the energy consumption was below 600kwh, lets say 500kwh, then the invoice would need to calculate 500kwh on the line with the (0-600kwh) and if it is more the 600kwh, as shown above, then the calculation needs to take the consumption figure and reduce it by 600 and then show the difference on the line(> 600kwh) and work out the amounts.

Would anyone like to have a crack at working out a formula for the above.

Many thanks
Dave
 
Hello FormR, can you assist with a formula for the following :

Would like to allocate numbers to customers on a Sheet and then recall the customer by inserting the allocated number :
Eg.
Page of 1 of Sheet
List of customers & their Reference numbers, 1 Jim 2 George 3 Jip 4 Alan 5 John

Page 2
1 Jim

_________
Page 3
2 George

_________
Page 4
3 Jip

________
Page 5
4 Alan

________
Page 6
5 John

________

So would like to call up(go to) customer 4 by inserting his number.

Thanks
Dave
 
Upvote 0

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Hi Dave,

Not sure I fully understand to be honest.

Maybe something like this (note you will need to change the commas "," to semi-colons ";" in the formula with your regional settings.

p.s. you would be a lot better off starting a new thread for new questions - you will get a lot more eyes looking at the problem for you that way.

Excel Workbook
AB
1RefName
21Jim
32George
43Fred
Sheet1
Excel Workbook
AB
1RefName
22George
Page 1
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,108
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top