In Excel: use =OR(A2>100, B2="urgent") when ANY condition being true is enough, and =AND(A2>100, B2="urgent") when ALL of them must be true — both usually sit inside an IF.
On this page8
Syntax
Arguments
| Argument | required / optional | Description |
|---|---|---|
logical1 | required | The first condition to test. Anything that evaluates to TRUE or FALSE. |
logical2 … | optional | Further conditions, up to 255. OR is TRUE when any one is TRUE; AND is TRUE only when all are. |
Related functions
IF(SUMIFS(C2:C100, A2:A100, "West") > 1000, "On target", "Below")Tests a condition: returns the 2nd argument if true, the 3rd if false.SUMIFS(C2:C100, A2:A100, "West") > 1000The left side is greater than the right side.SUMIFS(C2:C100, A2:A100, "West")Adds the cells that match every listed condition.C2:C100A reference to cells in your sheet.A2:A100A reference to cells in your sheet."West"A fixed value typed directly into the formula.1000A fixed value typed directly into the formula."On target"A fixed value typed directly into the formula."Below"A fixed value typed directly into the formula.Need it as an auditable file?
Ships inside the linked template — formula-driven, unlocked, audit-ready.
What this does
OR and AND take the same arguments and differ only in the rule they apply. OR returns TRUE when at least one condition holds; AND returns TRUE only when every one does. On their own they return the bare words TRUE or FALSE, which is rarely the point — they are almost always the first argument of an IF, which turns that verdict into a useful result: =IF(AND(…), "Approved", "Review"). Both accept up to 255 conditions. Two extra facts matter in practice. NOT(x) flips a result, so =IF(NOT(OR(…)), …) reads as "if none of these". And multiplying conditions does the same job inside array formulas, where (A2:A100="North")*(B2:B100>500) behaves as AND and adding them behaves as OR. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “and and or formula in excel”. Start on a copy or a tiny sample, keep the affected formula visible, and compare the result with the tool above before you touch the real workbook. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. The point is a calculation you can defend to a CFO or an auditor, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
An order is flagged when it is either large or marked urgent: =IF(OR(C2>1000, D2="urgent"), "Flag", "") — a €1,200 standard order and a €40 urgent order both get flagged. Approval instead needs both conditions: =IF(AND(C2>1000, D2="urgent"), "Approve", "Review") flags only the order that is large AND urgent. Nesting them expresses "urgent, and either large or from a key account": =IF(AND(D2="urgent", OR(C2>1000, E2="key")), "Approve", "Review"). Every business rule more complicated than a single comparison is built from "all of these" and "any of these", and OR and AND are how you write that down in a way the next person can check. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “and and or formula in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Writing
=IF(A2>100 OR B2="urgent", …)as ifORwere an operator; in Excel it is a function that takes the conditions as arguments. - Reaching for
ORwhen the rule is really "all of these", which lets a single condition wave everything through. - Comparing text with = and forgetting it is case-insensitive — use EXACT inside the condition when case matters.
- Using
ORacross a range,=OR(A2:A100>100), and expecting one answer per row; it returns a single TRUE for the whole range. - Leaving a bare
=AND(…)in a report cell, which shows TRUE or FALSE where a reader expects a label.
Frequently asked questions
What is the difference between OR and AND in Excel?
OR returns TRUE when at least one condition is true. AND returns TRUE only when every condition is true. They take exactly the same arguments.
How do I use OR inside an IF?
Put it in the first argument: =IF(OR(A2>100, B2="urgent"), "Flag", ""). The IF turns the TRUE/FALSE verdict into the text or number you actually want.
Can I combine OR and AND?
Yes, nest them: =IF(AND(D2="urgent", OR(C2>1000, E2="key")), "Approve", "Review") means urgent, and either large or a key account.
How many conditions can they take?
Up to 255 each. Beyond a handful, a helper column or a lookup table is usually easier to read and to audit than one long formula.
Other ways people ask this
People reach this page typing “how to use and or in excel”, “and or excel formula”, “using and or in excel” and “use and or in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “how to use and or in excel”, “and or excel formula”, “using and or in excel” all point at the one operation explained on this page, which is why they all lead here.