Help with Formula

D

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
 
B

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)
 
D

darrin

Bob said:
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top