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