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 ,
Please try this:
Filter(["A","B","C","D","E","F","G","H","I","J" ],Not(Value="A"||Value="E"))
Best regards,
Rimmon
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"]) )
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 545 Most Valuable Professional
Haque 314
Kalathiya 234 Super User 2026 Season 1
