try changing the order and testing for an error. I threw in the Proper
function to make sure the case is the same, otherwise I believe you will get
an error.
=IF(AND(ISERROR(FIND("Smith",PROPER(B1))),ISERROR( FIND("Jones",PROPER(B1)))),"Not Mine","Mine")
"toy4x4" wrote:
Ok, this works to start off:
=IF(FIND("Smith",B1),"Mine","Not Mine")
Problem is when Smith is not in the name I get #VALUE instead of "Not
Mine".
Then how to do nester ORs for Smith, Jones, etc.
Cause this doesn't work:
=IF(OR(FIND("Smith",B1),FIND("Jones",B1)),"Mine"," Not Mine")
I just get #VALUE
--
toy4x4
|