Solved: Multiple "IF" Statement

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
285
MS Excel 2007.
My electric bill has a graduated cost per KWH usage.
Total KWH used =1213.
1st 650 KWH =.052 Cents Per KWH
Next 350KWH=.045 Cents Per KWH
Over 1000 KWH=.042 Cents Per KWH

Is there a way to enter a less than and a more than factor in an "If" statement?

The 1st and last part is easy, but the middle "Next 350 Per KWH" gives me a problem.
I have a formula for making it work but it is very lengthy.
Is there a simple formula for computing this amount?

Thank you for your help.
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,454
yes , you could use

IF ( Kwh_CELL > 1000 , ((kwh_CELL - 1000)*.042)+(350*0.045)+(650*0.52) , IF(Kwh_CELL > 650, ((kwh_CELL - 650)*.045)+(650*0.052) , ((kwh_CELL * 0.052))

ie
=IF(A1>1000,((A1-1000)*0.042)+(350*0.045)+(650*0.52),IF(A1>650,((A1-650)*0.045)+(650*0.052),((A1*0.052))))

attached spreadsheet - use A2 to enter the Kwh - and the result is in D2

Note the > means that it needs to be greater than 650 for example
so 650 will be @ 0.052
and 651 will be 1 at 0.045
 

Attachments

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
285
yes , you could use

IF ( Kwh_CELL > 1000 , ((kwh_CELL - 1000)*.042)+(350*0.045)+(650*0.52) , IF(Kwh_CELL > 650, ((kwh_CELL - 650)*.045)+(650*0.052) , ((kwh_CELL * 0.052))

ie
=IF(A1>1000,((A1-1000)*0.042)+(350*0.045)+(650*0.52),IF(A1>650,((A1-650)*0.045)+(650*0.052),((A1*0.052))))

attached spreadsheet - use A2 to enter the Kwh - and the result is in D2

Note the > means that it needs to be greater than 650 for example
so 650 will be @ 0.045
and 651 will be 1 at 0.045
Thank you so much.
Have a great day
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top