Make decisions
Check two things at once (IF with AND)
=IF(AND(B2>=100,C2="Yes"),"Bonus","No bonus")How it works in Excel
- AND is true only if every test inside it is true.
- If so, the cell shows "Bonus".
- If not, it shows "No bonus".
- Swap AND for OR if only one test has to pass.
- You can put more tests inside AND, separated by commas.
The idea in general
Both things have to be true, like needing a ticket and an ID to get in.
What I assumed
- The number is in B2 and the Yes or No value is in C2.
Check the result on your own data before relying on it.