IF Any Column has a "NO" then True, Else False

[jamescosten]

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?

[#2 · Accepted solution]

@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)