HELP please! IF function for multible different numbers

martijnvanderveldt

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

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
I hope my formula is not an overkill

Do you need Something like this

Excel 2010
AB
63Good Mileage
712Good Mileage
89Poor Mileage
911Poor Mileage
Sheet8
Cell Formulas
RangeFormula
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"),"")

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!

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

Replies
1
Views
442
Replies
5
Views
228
Replies
1
Views
316
Replies
7
Views
679
Replies
6
Views
784

1,221,495
Messages
6,160,142
Members
451,624
Latest member
TheWes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back