IF statements???

  • Thread starter Christopher Anderson
  • Start date
C

Christopher Anderson

What would the syntax be for the following logic.

I want cell C8 to recognize whether or not cell A4 contains the word CRV.
Even if A4 contains other words in addition to CRV I want it to return a
"true" response to me. Is there a syntax for this command??

Chris
 
R

Ron Rosenfeld

What would the syntax be for the following logic.

I want cell C8 to recognize whether or not cell A4 contains the word CRV.
Even if A4 contains other words in addition to CRV I want it to return a
"true" response to me. Is there a syntax for this command??

Chris
Click to expand...


=NOT(ISERROR(FIND("CRV",A4)))

will return FALSE if CRV is not present and TRUE if it is present.

The formula is case-sensitive. For a case-insensitive formula, use SEARCH:

=NOT(ISERROR(SEARCH("CRV",A4)))


--ron
 
C

Christopher Anderson

Ron Rosenfeld said:
=NOT(ISERROR(FIND("CRV",A4)))

will return FALSE if CRV is not present and TRUE if it is present.

The formula is case-sensitive. For a case-insensitive formula, use SEARCH:

=NOT(ISERROR(SEARCH("CRV",A4)))


--ron
Click to expand...

Ron:

You be da man!!!

Thanks

Chris
 
Top