IF function using multible numbers

martijnvanderveldt

New member
Joined
Sep 10, 2014
Messages
10
Reaction score
0
Points
0
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
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

=IF(OR(A2={1,3,4,6,7,8,10,12}),"Has good mileage","has poor mileage")
 
Top