(Excel) If any one column of a certain set of columns contains a certain value, then output something

Yesterday I've been wrestling to get a working IF statement with AND & OR conditions, so far I haven't succeeded.

Excel example

In my picture you can see some of the columns I'm trying to test for certain values. If any of the highlighted columns contains a 1 I want to report in a new column the value "No".

So far it seems I need to use a IF function with both AND & OR, but I haven't been able to get it right. Anyone have suggestions?