help with formula

[ss]

Could someone do this formula for me, its regarding my gas bill.
I have managed to get the formula ok to convert to kWh on my daily usage.
I now want to convert to a monetry value.

Example my total usage Kwh so far are 2790
The first 631 kWh are charged at 8.224p ( Thats uk pence)
above that is charged at 3.73p

What formula to do this, the formula would be in cell K16
The total kWh in cell H15.

so 631 x 8.224 = £51.89
plus 2159 x 3.73 = £80.53
total sum in K16 would be £132.42

thank you

 

[Claus Busch]

Hi,

Am Fri, 21 Dec 2012 18:12:22 +0000 schrieb ss:

Example my total usage Kwh so far are 2790
The first 631 kWh are charged at 8.224p ( Thats uk pence)
above that is charged at 3.73p

What formula to do this, the formula would be in cell K16
The total kWh in cell H15.

try:
=631*0,08224+(H15-631)*0,0373


Regards
Claus Busch

 

[Claus Busch]

Hi,

Am Fri, 21 Dec 2012 19:19:57 +0100 schrieb Claus Busch:

try:
=631*0,08224+(H15-631)*0,0373

better:
=IF(H15<632,H15*0.08224,631*0.08224+(H15-631)*0.0373)


Regards
Claus Busch

 

[ss]

Hi,

Am Fri, 21 Dec 2012 19:19:57 +0100 schrieb Claus Busch:


better:
=IF(H15<632,H15*0.08224,631*0.08224+(H15-631)*0.0373)


Regards
Claus Busch

Spot on, works a treat.
Thank you so much