# Searching (2) different cells

#### O177812

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

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Excel 2010
ABC
1heat safeERROR
2not safeGOOD
31heat safeGOOD
Sheet1
Cell Formulas
RangeFormula
C1=IF(AND(ISNUMBER(FIND("°",A1)),ISNUMBER(FIND("heat safe",B1))),"ERROR","GOOD")

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

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?

Replies
16
Views
606
Replies
58
Views
2K
Replies
2
Views
408
Replies
10
Views
249
Replies
17
Views
898

1,206,754
Messages
6,074,749
Members
446,082
Latest member
fgiron83

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