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:


Any ideas?

  • 1
    Or function : try this instead =or(c2="Newspaper",c2="Magazine") – pjmg Oct 30 at 10:32

Your Answer

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

Browse other questions tagged or ask your own question.