Thanks Vasant.
Now what if the rate calculation gets more complicated? Is there some way
to use a lookup table? For example:
0-600 costs .06 per kwH
601-800 costs .08 per kwH over 600
801-1000 costs .10 per kwH over 800
1001-1200 costs .15 per kwH over 1000
1200 costs .30 per kwH over 1200
"Vasant Nanavati" wrote:
=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?