HELP please! IF function for multible different numbers

[martijnvanderveldt]

Hi!

I want to try to use the IF function to make a car option with both positive and negative attributes out of 12 ratings a participant gives about these 12 attributes. For the car i want the following ratings to be positive: 1,3,4,6,7,8,10,12, whereas the others inbetween are supposed to be negative (2,5,9,11) . I made the following formula, but it does not seem to do what i want:

=IF(A2=1+AND(3,4,6,7,8,10,12),"Has good mileage","has poor mileage")

There is something wrong in the formula i just don't know what it is. the OR function also does not seem to work. Does anyone have a clue how i can make these ratings the positive ones while the other onesare negtive?

I really apreciate the help

 

[Momentman]

I hope my formula is not an overkill

Do you need Something like this

Excel 2010
	A	B
6	3	Good Mileage
7	12	Good Mileage
8	9	Poor Mileage
9	11	Poor Mileage
Sheet8

Cell Formulas
Range	Formula
B6	=IFERROR(IF(MATCH(A6,{1,3,4,6,7,8,10,12},0)>0,"Good Mileage"),"") & IFERROR(IF(MATCH(A6,{2,5,9,11},0)>0,"Poor Mileage"),"")

 

[martijnvanderveldt]

Your formula does not seem to work in My excel (2010 Holland), but i found a working formula!

=IF(ISERROR(MATCH(A2;{2;5;9;11};0));"Has good mileage";"Has poor mileage")

If i have any more questions i will let you know. Thank you so much!

 

[Momentman]

My formula would have been shorter but I didnt want to assume that anything not 2,5,9,11 would be bad, 'cos some naughty person could put a value greater than 12

Maybe the formula not working has something to do with colon( being your separator while comma(,) being mine. Just guessing