Re: Calculating a bill using a graduated rate...

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 Smith@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:321B2696-2884-488C-81B5-21542439AA93@xxxxxxxxxxxxxxxx
> > 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?
>
>
>
.

Relevant Pages

  • Re: What do I need to conserve power on my old Linux box?
    ... So it's one government body regulating a bunch of arm's length government bodies and crown corporations. ... for residential and small business customers (which are defined as those using less than 250,000 kWh per year). ... On top of that are delivery fees, regulatory fees, and a "debt retirement charge" to cover stranded debt left behind after the government restructured things a few years back. ... So it's just the four basic categories of costs. ...
    (comp.os.linux.hardware)
  • Re: attn: William Mook - How is your company doing?
    ... > this means the equipment incurs a cost of about $0.03 per watt year. ... > kWh or more per year. ... to pour concrete for their projected costs much less install and operate ... They may go broke trying but go ...
    (sci.energy.hydrogen)
  • Re: Mooks quote about nuclear being a "low grade heat". Is it true?
    ... Energy is Power x Time. ... we calculate total contribution of the capital cost to a kWh as ... and if a nuclear plant costs $5 per watt and lasts 30 years and is ...
    (sci.energy)
  • Re: Increasing energy costs
    ... construction, operational, and decommissioning costs.. ... two refuelings, replacing 1/3 of fuel rods every 1.5 years ... dollars per kWh or 77.5 cents per kWh in U3O8 costs.. ...
    (sci.energy)
  • Re: Increasing energy costs
    ... construction, operational, and decommissioning costs.. ... two refuelings, replacing 1/3 of fuel rods every 1.5 years ... dollars per kWh or 77.5 cents per kWh in U3O8 costs.. ...
    (sci.energy)
Loading