Searching (2) different cells

[O177812]

IF cell A contains a "°" and cell B contains the phrase "heat safe" then enter the word "ERROR", if false enter "GOOD".

Here is what I have written so far but it only works for the True:

=IF(AND(FIND("heat safe",V11,1), FIND("°",S11,1)), "ERROR", "GOOD")

Help Appreciated.

 

[Comfy]

Excel 2010
	A	B	C
1		heat safe	ERROR
2		not safe	GOOD
3	1	heat safe	GOOD
Sheet1

Cell Formulas
Range	Formula
C1	=IF(AND(ISNUMBER(FIND("°",A1)),ISNUMBER(FIND("heat safe",B1))),"ERROR","GOOD")

 

[O177812]

I am adding this to an OR statement and it is not working correctly can you assist?

=IF(OR(MID(S8,FIND("°",S8)-3,3)<>MID(V8,FIND("°",V8)-3,3), AND(ISNUMBER(FIND("°",S8)),ISNUMBER(FIND("heat safe",V8)))), "ERROR", "GOOD")

 

[Comfy]

I am adding this to an OR statement and it is not working correctly can you assist?

=IF(OR(MID(S8,FIND("°",S8)-3,3)<>MID(V8,FIND("°",V8)-3,3), AND(ISNUMBER(FIND("°",S8)),ISNUMBER(FIND("heat safe",V8)))), "ERROR", "GOOD")

Can you be more specific? Why isn't it working correctly?

Can you provide some source data for us to work with?