If statements...causing trouble!

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

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

=IF(e7=0,"",IF(e7=<3,e7*100,IF(e7=<6,e7*200,IF(e7=<10,e7*300,IF(e7=>10,"","")))))

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
0