If statements...causing trouble!

KC-Excel - Aug 20, 2010 at 12:54 PM
 IneptMacro - Aug 20, 2010 at 02:39 PM

I'm trying to figure how i would create a formula that would capture the following...

If E7 is >=1 but <=3 multiply E7 by 100
If E7 is >=4 but <=6 multiply E7 by 200
If E7 is >=7 but <=10 multiply E7 by 300

I'm stuck at... =IF(AND(E7>=1,E7<=3),E7*100),IF(AND(E7>=4,E7<=6),E7*200)

please help!!!!

1 response


What is happening here is,

If e7 is zero then blank, if it's less than 3 then *100, less than 6 then *200, less than 10 then *300, more than 10 then blank.

You may need to play with it, like if this doesn't work right then use >11 at the end instead of 10 but excel should be alright with overriding the previous "IF" when the next one is a better match.

If this works, you will be my first "answered" - I look foreward to that moment since this site has answered so many of my excel issues