Four columns, one decision, and every row needs a different answer. That is the moment a single IF stops being enough — and most tutorials stop teaching too. If you have tried to combine multiple IF statements in Excel and ended up with a formula that closes with more parentheses than it opens, you are not missing the concept. You are missing the structure. Writing formulas with clear logic beats memorizing syntax, and this guide gives you that logic: three working structures, eight copy-ready examples, and a fast way to pick the right one.

One row, three conditions: a formula that actually solves it

Let’s start with the concrete problem. Say you manage a small sales sheet. Column A holds each rep’s revenue, column B the monthly target, and column C the region. Your manager wants three outcomes:

  • Bonus — revenue at or above target and region is East
  • Review — revenue within 10% below target
  • No pay — everything else
A (Revenue) B (Target) C (Region)
250 200 East
195 200 West
160 200 East

The classic answer is a nested IF that wraps two AND checks:

=IF(AND(A2>=B2, C2="East"), "Bonus",
  IF(AND(A2>=B2*0.9), "Review", "No"))

Row 1 returns Bonus (250 ≥ 200, region East). Row 2 returns Review (195 misses target but clears 180, which is 90% of 200). Row 3 returns No (160 is below 180). The trick is that AND(A2>=B2*0.9) is perfectly legal with a single argument — AND is just a condition wrapper, and Excel treats a lone logical value as itself.

Three ways to combine conditions in Excel

Every “multiple IF” formula you will ever write falls into one of three shapes. Knowing the shape before typing is what keeps the parentheses sane:

Structure Best for Limit
Nested IF chain Ordered, mutually exclusive outcomes (tiers, grades, status) Readability collapses around 4-5 levels
IFS Long chains of conditions in one flat formula Excel 2019+ / 365 only
Single IF + AND/OR Several conditions that must all hold (or any one) Only one yes/no outcome

Most real-world formulas mix two of the three — for example, an IFS chain where each condition is an AND block. The examples below build up from simple to mixed.

Method 1 — nested IF: the decision chain

Nested IF reads as an ordered list of questions. The first TRUE condition wins, and everything after it is ignored. That ordering is the logic, so list conditions from most specific to most general.

Grade a score out of 100 (column A):

=IF(A2>=90, "A",
  IF(A2>=80, "B",
    IF(A2>=70, "C", "F")))

A score of 84 walks the chain: 84 ≥ 90? No. 84 ≥ 80? Yes → B. Notice the final "F" is not a condition — it is the catch-all for “none of the above,” and you should almost always end a chain with one.

The same shape works with multiple fields. If column B is a bonus flag, combine them:

=IF(AND(A2>=90, B2="Yes"), "A+",
  IF(AND(A2>=90, B2="No"), "A-",
    IF(A2>=80, "B", "Other")))

A score of 92 with B2 = “No” skips the first test (B2 fails) and lands on A-. If you find yourself indenting a fourth level, stop and reach for IFS.

Method 2 — IFS: flatten the chain

IFS takes the same decision chain but drops the nested parentheses. Each condition and its result sits side by side, so the formula reads like a table:

=IFS(A2>=90, "A",
  A2>=80, "B",
  A2>=70, "C",
  TRUE, "F")

Same results as the nested version, no pyramid. Two rules make IFS reliable:

  1. Conditions are evaluated top to bottom, and the first TRUE wins — exactly like nested IF, so keep the most specific condition first.
  2. If no condition is TRUE, IFS returns #N/A. The final TRUE, "F" pair is your catch-all and prevents that error. (It is the same reason people pair lookups with error handling — if you use lookups in the same sheet, see our XLOOKUP vs VLOOKUP guide, where built-in not-found handling removes this whole class of bug.)

IFS needs Excel 2019 or later, or Excel 365. In older versions, or in a workbook you share with clients on old installs, the nested IF above behaves identically everywhere.

Method 3 — AND and OR inside a single IF

When you only need one yes/no answer, you do not need nesting at all. AND requires all conditions to be true; OR requires any of them.

Escalate tickets that are urgent or over $500 (column A status, column B cost):

=IF(OR(A2="Urgent", B2>500), "Escalate", "Standard")

Route orders that ship from either warehouse but only when inventory is confirmed:

=IF(AND(B2="Confirmed", OR(C2="East", C2="West")), "Ship", "Hold")

That last formula is the pattern worth memorizing: AND outside, OR inside. It says “B must be Confirmed, and C must be East or West.” Getting it backwards — OR(B2="Confirmed", AND(...)) — silently changes the business rule from “both” to “either,” and the spreadsheet still shows no error at all.

Which structure should you choose?

Your situation Use Why
2-3 ordered outcomes (tier, grade, status) Nested IF Short, works in every Excel version
4+ ordered outcomes IFS Flat, scannable, easy to reorder
One yes/no with several required conditions IF + AND No nesting needed
One yes/no where any condition qualifies IF + OR No nesting needed
Ordered outcomes, each with multiple conditions IFS with AND blocks =IFS(AND(A2>=90,B2="Yes"),"Gold",AND(A2>=80,B2="Yes"),"Silver",TRUE,"None")

Combine IF with lookups and error handling

Conditional logic rarely lives alone. Two safe, common pairings:

Run a lookup only when the condition holds. Return a commission rate from a table in D2:E100, but only for active accounts over $100:

=IF(AND(A2<>"", B2>100),
  VLOOKUP(A2, D2:E100, 2, FALSE),
  "")

Rows that fail the condition show a blank instead of an ugly #N/A, because the lookup never runs at all.

Wrap the whole thing in IFERROR. If a calculation can blow up (division by zero, a misspelled name), put the safety net on the outside:

=IFERROR(IF(A2>0, 1000/A2, 0), "Check input")

For date-based conditions, the same logic applies — a SUMIFS that only fires on the right rows is a close cousin of this pattern, covered in our SUMIFS date range guide. And if your “formula” is starting to need loops, dates, and file saving, that is the line where a macro takes over — our guide to macros in Excel explains where each tool stops.

Five mistakes that break combined IF formulas

  1. Putting the most general condition first. =IFS(A2>0, "Positive", A2>=90, "Elite") hands every positive number to “Positive” and the second rule never runs. Most specific first, always.
  2. Forgetting the catch-all. IFS without a final TRUE, "..." returns #N/A for any value your conditions miss — usually one blank cell’s worth of surprise.
  3. Swapping AND and OR. AND(A, B, OR(C, D)) means “A and B and (C or D).” Writing OR(A, B, C) when you meant “A and (B or C)” changes the rule and produces no error.
  4. Comparing text with > or <. Text comparison in Excel is alphabetical and locale-sensitive. "10"<"9" is TRUE. Convert or use EXACT() for text tests.
  5. Trusting a blank cell. In AND(A2>5, B2<10) a blank A2 compares as 0, so the condition quietly fails. Test emptiness explicitly: IF(A2="", "", ...).

Frequently Asked Questions

Can I combine IF statements with AND and OR in the same formula?

Yes. Nest them: =IF(AND(A2>100, OR(B2="A", B2="B")), "Yes", "No"). AND and OR can each contain up to 255 conditions, and you can put an OR block inside an AND block (or vice versa) as many times as you need.

What is the difference between nested IF and IFS?

None in results — IFS is a flatter spelling of the same ordered chain. IFS is easier to read and reorder, but it requires Excel 2019+ / 365. Nested IF runs in every version and is fine up to about four levels.

Why does my combined IF formula always return FALSE?

Usually one condition in an AND block is failing silently — a blank cell treated as 0, a text value compared against a number, or a trailing space (“East “). Test each condition separately in a scratch column before combining them, and wrap text cells in TRIM().

How many IF statements can I nest in Excel?

Excel 2019 and later allow 64 levels of nested IF. Older versions allow 7. But six or more levels is a readability warning, not a capability ceiling — switch to IFS at that point.

Do I need IFS, or is it a Microsoft 365-only trick?

IFS ships with Excel 2019, 2021, and 365 on Windows and Mac, and with Excel for web. If a workbook must open correctly on an older install (Office 2016 and earlier), stick to nested IF — or save a copy in “compatibility mode” if you need both.

Bottom line

Combine conditions in one of three shapes: an ordered chain (nested IF or IFS), a single AND block, or a single OR block — and mix them when a rule needs both. Order your conditions from specific to general, keep a catch-all, and test each condition alone before joining them. Your spreadsheet will do the one thing you actually meant, and the formula will still make sense when you come back next quarter.

Want to skip the guesswork? Describe what you need in plain English and let ai-excel.net generate the formula for you.