Forum Discussion

jamescosten's avatar
jamescosten
Copper Contributor
May 01, 2024
Solved

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"...
SharePoint Online
  • Rob_Elliott's avatar
    Rob_Elliott
    May 01, 2024

    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)

Rob_Elliott's avatar
Rob_Elliott
Bronze Contributor
May 01, 2024

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)

Resources