View Single Post
  #2   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

=IF(A1<=600,A1*0.06,36+(A1-600)*0.08)

--

Vasant



"Dave Smith" <Dave wrote in message
...
I'm trying to calculate an electricity bill which uses different values

based
on the amount used. For the first 600 kwh, the charge is .06/kwh. For
anything above 600 kwh, the charge is .08/kwh. So if my usage is 700 kwh,

my
bill is $36+$8. Any ideas on which formula I should use for this?