help with formula

S

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
 
C

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
 
C

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top