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"")


Only top voted, non community-wiki answers of a minimum length are eligible