I need help trying to figure this out. I am extremely new to formulas and very confused.

Here is my thought process:
IF B1 contains a comma AND C1 is exactly "none" THEN I want C1 to be replaced with "USA".

Screenshot of my test sheet

Do I need a new column to make this happen? or could I some how use Conditional formatting? I've really only used formulas in Conditional Formatting so I'm not sure where to start.

Here is the link to a spreadsheet if you need it https://docs.google.com/spreadsheets/d/1cHtJg04BLrwvWBFaqy5VeSRJSjlA9qQcnNePZLI8u7M/edit?usp=sharing

1 Answer 1


You could use the following formula in cell D3 (or anywhere else you may need to).

=IF(AND(REGEXMATCH(B3, ","),C3="none"), "USA","Oops")

(Of course you can change "Oops" to whatever you like or even a blank cell"")

  • Please remember that as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. Mar 24, 2020 at 19:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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