Electricity Acc. Formula

[country rose]

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

 

[country rose]

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

 

[FormR]

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
	A	B
1	Ref	Name
2	1	Jim
3	2	George
4	3	Fred
Sheet1

Excel Workbook
	A	B
1	Ref	Name
2	2	George
Page 1

 

[country rose]

Thanks FormR , will try this out tomorrow