Help with Formula

[darrin]

I am trying to find an easy way to to calculate my Electric bill, my
problem is that there are three tiers of pricing. Example the 1st 500
kwh are billed at 10 cents, 501 - 1000 kwh are billed at 8 cents, and
then anything over 1000 is billed at 6 cents.

I have my total usage in A2 but would like to break down the total cast
by the three tiers, in B2,C2 and D2. Any suggestions???

Thanks

 

[Bob Phillips]

=MIN(A1,500)*0.1+MIN(MAX(0,A1-500),500)*0.08+MAX(0,A1-1000)*0.06

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[darrin]

=MIN(A1,500)*0.1+MIN(MAX(0,A1-500),500)*0.08+MAX(0,A1-1000)*0.06

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

Thank you both so much, They both worked just fine and Bob you gave me
the ability to change the numbers if the rates change.

Thanks again