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
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
