IF statements???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

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

Vlookup Question..if text lookup_value do not match with table_arr 11
If Statement 5
How to select a special word out of a cell 2
Find the first cell to contain text in a column 7
Can I add more than 2 comparisons to an IF statement?? 3
Compare the value of 2 cells and get Flase/true statement 3
help with a IF formula 9
Combining Text From Cells 3

Back
Top