Logical statement for 'contains' ?

S

Singh

Is there a logical statement to return 'True' if one cell contains the
contents of another (and maybe more).

E.g.
Cell 1 = 12345
Cell 2 = 123456789
Cell 3 = 987654321

Logical statement would return true for cell 1 against 2, but not for cell 1
against 3.

Thanks.
 
D

Don Guillett

Where j5 is what you seek

=IF(ISERR(FIND($J$5,J6)),"no","yes") yes
=IF(ISERR(FIND($J$5,J7)),"no","yes") no
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Three possible outputs from an if statement. 3
"IF" Function 1
How fill series containing one variable and one fixed value in XL 1
Logical Test for a value in a named list? 10
Multiple if statements 5
Check if text exists within a cell range and return logical vaule - possible? 2
Function for "Contains" 5
If statement with dates 0

Top