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

=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

  • Calculating a bill using a graduated rate...
    ... 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. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: What do I need to conserve power on my old Linux box?
    ... HOSTNAME: MyBox ... Check your last electricity bill to see how much you pay per kWh and you'll know exactly how much your computer is costing you per month. ... I took a quick look at the SCE website but couldn't find any definitive rate information, just a lot of complex rate tiers. ...
    (comp.os.linux.hardware)
  • Re: What do I need to conserve power on my old Linux box?
    ... LOADPCT: 39.0 Percent Load Capacity ... Check your last electricity bill to see how much you pay per kWh and you'll know exactly how much your computer is costing you per month. ... AFAICT, about 10 cents per kWh is a reasonable estimate in North America, so I'd guess that running your computer 24/7 is costing you less than $25/month. ...
    (comp.os.linux.hardware)
  • Re: Large electric bill - advice sought
    ... for the electricity bill since. ... Send them a cheque with your letter for this amount stating ... that your cheque is "full and final payment in regard to this bill". ... Once they cash your cheque, ...
    (uk.legal)
  • Re: Calculating a bill using a graduated rate...
    ... Bernard V Liengme ... remove caps from email ... > I'm trying to calculate an electricity bill which uses different values ... > on the amount used. ...
    (microsoft.public.excel.worksheet.functions)
Loading