Thread
:
Calculating a bill using a graduated rate...
View Single Post
#
2
Vasant Nanavati
Posts: n/a
=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?
Reply With Quote