# I Need help with my IF(OR statement

#### O177812

##### Board Regular
I can't seem to make it work when the statement is False

=IF(OR(MID(S8,FIND("°",S8)-3,3)<>MID(V8,FIND("°",V8)-3,3), AND(ISNUMBER(FIND("°",S8)),ISNUMBER(FIND("heat safe",V8))), AND(OR(V8={"Oven","°"}),COUNTIF(S8,"<>*°*"))), "ERROR", S8)

can someone help?

Last edited:

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
I'm not sure the V8={"Oven","°"} works they way you think. Did you mean to have an array, or did you mean V8="Oven" or V8="°"?
Edit: Nevermind! I missed on my own testing, and the OR(
V8={"Oven","°"}) worked as I imagined you meant. Sorry!

Last edited:
This is the my progress so far and it is working for almost all processes except the (2) listed in bold.

=IF(OR(MID(JE2,FIND("°",JE2)-3,3)<>MID(NS2,FIND("°",NS2)-3,3), AND(ISNUMBER(FIND("°",JE2)),ISNUMBER(FIND("heat safe",NS2))), AND(OR(NS2={"Oven","°"}),COUNTIF(JE2,"<>*°*")), NS2=""), "ERROR", JE2)

What is the exact issue? Is the bold part not coming up with the expected answer? The formula make it seem that you want both NS2 to have either Oven or ° and to have JE2 to not contain °. Is that correct?

It's difficult (to say the least) to 'fix' a broken formula that doesn't do what you want.
It's usually much easier to work from scratch based on a worded description of what you want.

Can you just describe in words what it is you want to achieve?

I have fixed almost all of it.

I need to check the text of a vlookup to see if it does not contain a degree symbol.

=IF(AND(SEARCH("°", NS446),COUNTIF(Vlookup(A2, DATA, 3, FALSE), *<>*°*")), "ERROR", "GOOD")

Replies
3
Views
279
Replies
13
Views
630
L
Replies
3
Views
220
Replies
11
Views
2K
Replies
1
Views
261

1,196,328
Messages
6,014,676
Members
441,835
Latest member
rthomas268

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

### Which adblocker are you using?

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