1

First of all sorry if I am not clear. it is my first question. I am trying to make a cell give an output with IF(REGEXMATCH on the cell A1 for example

=IF(RegExMatch(A2,"YES"),"Good"

I also need the same cell to give another output based on another cell

=IF(RegExMatch(A3,"NO"),"OK"

Important to say, both terms will never give TRUE at the same time, so basically give the output of the argument that returns a TRUE case. my bottom question is how to combine both terms and make only the one that is TRUE to return an output without being dependent on the other term.

0

=ARRAYFORMULA(IF(REGEXMATCH(A2:A, "YES"), "Good",
              IF(REGEXMATCH(A2:A, "NO"),  "OK", )))

0

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.