if error !!!

[deecarrion]

Help!

What is wrong here? Why isn't it working?

=IF((i7)<=10,"Low 10%", =IF(( i7) <=30 and >10,"Low Mid 11-30%",= IF((i7) <=60 and >30 , " Mid Range 31-60%",=if((i7) <=80 and >60,"High Mid 61-80%",=if((i7) <=100 and >80 ,"High 81-100%","error"))

 

[Jonmo1]

in your 2nd IF (and all after that)
You don't have to test for >10
Because if the value WAS <= 10, then the FIRST IF would have been true, and returned LOW 10%

So you can just remove all the and parts.
And remove all the = symbols on each of the IFs, except the very first one.
And you need to add a bunch of ) to the end.
There should be 1 ) for every IF in the formula.

 

[dave3009]

Yip, you don't need to test the lower value so you can go with

=IF(I7<=10,"Low 10%",IF(I7<=30,"Low Mid 11-30%",IF(I7<=60," Mid Range 31-60%",IF(I7<=80,"High Mid 61-80%",IF(I7<=100,"High 81-100%","error")))))

Or another option might be

=LOOKUP(I7, {0,10,30,60,80,100}, {"Low 10%","Low Mid 11-30%","Mid Range 31-60%","High Mid 61-80%","High 81-100%","Over 100%"})

 

[deecarrion]

Thank you, I used the lookup! much cleaner!

 

[deecarrion]

Thank you so much for your reply! Helps me to understand what I'm doing wrong.