I Need help with my IF(OR statement

[O177812]

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?

 

[AliMass]

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!

 

[O177812]

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)

 

[AliMass]

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?

 

[Jonmo1]

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?

 

[O177812]

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