Jens
Reputation: 3
(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.
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?
Upvotes: 0
Views: 960
Answers (1)
Related Questions
- Find if column contains value from another column?
- Excel Formula - If any cells within a range contain specific value, then
- Formula to check if all non-empty columns have a particular value
- Excel IF multiple columns
- Excel - Check if column has specific text
- VBA check if columns contains specific value
- Excel help - if keyword exists in a column for each row
- if two columns contain specific text, return true in separate column
- Check if column contains specific values in excel
- In Excel, how do I determine if a specific cell with multiple values contains a specific value?