Combining AND & OR in a formula

Emma Pettit

I have a sheet with the following three columns:

--Was the question asked

--Answer 1 y/n

--Answer 2 y/n

I want the formula to turn the flag red (cell already formatted for flags) if the question was asked, and either answer 1 or answer 2 were no (aka, i need all the no's from everyone who was asked the question).

So far I was able to build the OR piece but I can't figure out how to add in the AND.

I have: =IF(OR([Answer 1]@row = 0, [Answer 2]@row = 0), 1, 0)

Thank you for your help!

Andrée Starå

Hi Emma,

Try something like this.

=IF(AND(OR([Answer 1 y/n]@row = 0; [Answer 2 y/n]@row = 0); [Was the question asked]@row = 1); 1)

The same version but with the below changes for your and others convenience.

=IF(AND(OR([Answer 1 y/n]@row = 0, [Answer 2 y/n]@row = 0), [Was the question asked]@row = 1), 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!