Forum Discussion
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?
jamescosten you need to use OR as in the example below:
=IF(OR(Fruit="Banana", Fruit="Apple"),"Yes","No")Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
1 Reply
jamescosten you need to use OR as in the example below:
=IF(OR(Fruit="Banana", Fruit="Apple"),"Yes","No")Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)