View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 29
Default Or's with If's Statements

This is true. It's jkind of a habit of mine to include the operator in
there, even when it's only necessary to check true or false. Thanks for
pointing that out.


"Rick Rothstein (MVP - VB)" wrote in
message ...
=IF(COUNTIF(A1:A6,"CertainWord")0,"Word exists.","Word does NOT exist.")


You can leave the 0 out and it will still work, right?

Rick