Notifications
Announcements
Say I have options A,B,C,D,E,F,G,H,I,J and i want to see all that are neither A or E
what formula would I write
I have tried using IF(option<>or(A,E)) but this gives a warning
Any help would be much appreciated
Hi @Lynch66
Judging by your formula, if you want to use the If statement to test if "option" is not either A or E, the syntax would look like this:
If (Not(option in ["A", "B"]), Notify("option is NOT A or B", Notify("option IS A or B" )
As @v-mengmli-msft says , you can use this type of syntax to exclude A & E from the options.
Filter(["A","B","C","D","E","F","G","H","I","J" ], Not(Value in ["A", "B"]) )
Hi @Lynch66 ,
Please try this:
Filter(["A","B","C","D","E","F","G","H","I","J" ],Not(Value="A"||Value="E"))
Best regards,
Rimmon
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 428
WarrenBelz 374 Most Valuable Professional
MS.Ragavendar 333 Super User 2025 Season 2