Make decisions
Pass if at least one thing is true (IF with OR)
=IF(OR(B2="Yes",C2="Yes"),"Approved","Denied")How it works in Excel
- OR is true if any test inside it is true.
- If so, the cell shows "Approved".
- If every test fails, it shows "Denied".
- Swap OR for AND if every test has to pass.
- You can add more tests, separated by commas.
The idea in general
Either one is enough, like getting in with a ticket or a staff badge.
What I assumed
- The two values are in B2 and C2.
Check the result on your own data before relying on it.