IF Any Column has a “NO” then True, Else False
I have a series of columns that if the value is NO then I want the calculated column to Say No, and if none present say yes.
I have tried this: =IF(([Column1]=”NO”),IF([Column2]=”NO”)…etc),”No”,”Yes”))
Am i missing something?
I have a series of columns that if the value is NO then I want the calculated column to Say No, and if none present say yes. I have tried this: =IF(([Column1]=”NO”),IF([Column2]=”NO”)…etc),”No”,”Yes”)) Am i missing something? Read More