Reputation: 271
=IF(OR(REGEXMATCH(C3,"A"),REGEXMATCH(C3,"+"),REGEXMATCH(C3,"G")),1,0)
In Google Sheets, I'm using the above formula to output 1
if either A
, +
or G
characters are present in cell C3. Some example values for C3 are AG+
, ABCDKHN$%
, GHXV
, etc, those will lead the formula to output 1
.
The +
character ends up with this error:
How can I convert the +
character for the REGEXMATCH formula to look for it in a string successfully?
Upvotes: 2
Views: 77