If cell CONTAINS...

R

Rasmus

Is it possible to fix this line:

=IF(C40="BARCODE";("Check barcode");"")

to display the 'Check barcode' message if C40 CONTAINS 'BARCODE' (and is not
EQUAL TO) ?

I have to put a whole bunch of other stuff in C40 as well so a <> won't do
the trick I'm afraid.

(c:
Rasmus
 
L

Lance

Wildcards work in the countif statement

=IF(COUNTIF(C40,"*BARCODE*")>0;"Check barcode";"")

Lance
 

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

Auto Detect Data, Auto Print Data, Auto Erase Data Loop 16
Replace or insert characters in text string 6
Error in cell formula 12
Need some help please 1
Copy cell change to other workbook 5
paste info to all open workbooks (first free line can vary) 0
My barcodes won't print! 5
Excel VBA - Printing filtered records 2

Top