I want to mark a checkbox if adjacent cell contains specific text.
Like for instance, cell C2 can have these values: Newspaper Magazine Website Facebook
Cell c3 which is a checkbox, will be marked if c2 is labeled Newspaper OR magazine, and unchecked if not..
All my formulas so far has returned error. It works if I test for only one statement, but when I try to test for multiple statements it fails.
I've tried this formula in C3: