Another possibility is =A1*0.06+(A1600)*(A1-600)*0.02
best wishes--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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?