If cell CONTAINS...

  • Thread starter Thread starter Rasmus
  • Start date Start date
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
 
Wildcards work in the countif statement

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

Lance
 
Back
Top