How to determine the values? - Microsoft Community

i know on how code on following conditions

if given cell contains "a" or "b" character string, return true else false

does have suggestions?
in advance suggestions

let's cell text a1.

the formula

=or(isnumber(find({"a","b"},a1)))

will return true if a1 contains "a" or "b" (or both), , false otherwise.

this case sensitive: "a" , "b" won't count. if want case insensitive, use

=or(isnumber(search({"a","b"},a1)))

Office / Excel / Windows other / Older versions