WORKPLACE SKILLS · PRACTICAL GUIDE
Excel AND and OR: Write the Rule Before the Formula
Put Ready in A2 and 5 in B2. A row can qualify either when both conditions are met or when at least one is met.
The idea behind the exercise
AND requires every condition to be true. OR requires at least one condition to be true; the choice must match the business rule.
Practise Excel AND and OR in a scratch workbook
Compare =AND(A2="Ready",B2>=5) with =OR(A2="Ready",B2>=5).
Use a separate practice sheet rather than changing an important workbook. Keep the stated inputs visible and label the result cell. Predict the result before checking Excel so that the exercise tests your understanding instead of your ability to copy instructions.
A mistake to check
A formula can run correctly while implementing the wrong rule. Say the requirement in ordinary words before choosing AND or OR.
Change one condition and test again
Change A2 to Pending and keep B2 at 4. Both formulas should now return FALSE.
Write one sentence explaining why the result changed or stayed the same. If it differs from your prediction, inspect the entered values, the formula or selected range and the rule you intended to use. Change one thing at a time so the cause of the difference remains visible.
Version and locale notes
Examples use English function names and commas between arguments. Your regional settings may use semicolons, different decimal or date formats, or localised function names. Menu wording and feature availability can differ by Excel version; consult the provider documentation for your installation.
For provider documentation and related feature details, visit Microsoft Excel Support. The dataset and practice steps in this article are original examples from The Job Tests.
Continue with Excel IF: Test a Boundary Value, Not Only an Obvious Case for an earlier guide in this series.
Original educational content by The Job Tests, operated by Sasflynet Kft. No diagnosis, certification or hiring outcome is promised.