How to Use IF with Multiple Conditions in Excel

IF with AND — all conditions must be true

=IF(AND(A2>100, B2="Active"), "Qualify", "No")
-- Both conditions must be true to return "Qualify"

=IF(AND(A2>=18, A2<=65, C2="UK"), "Eligible", "Not eligible")
-- Three conditions — all must be true

IF with OR — any condition can be true

=IF(OR(A2="North", A2="South"), "UK", "International")
-- Either region qualifies

=IF(OR(B2<0, B2>10000), "FLAG", "OK")
-- Flag if value is negative OR over 10,000

Nested IF — multiple outcomes

=IF(A2>=90, "A",
  IF(A2>=80, "B",
    IF(A2>=70, "C",
      IF(A2>=60, "D", "F"))))
-- Grade based on score
-- Each IF is inside the false branch of the previous IF

IFS — cleaner than nested IF

=IFS(A2>=90,"A", A2>=80,"B", A2>=70,"C", A2>=60,"D", TRUE,"F")
-- Same result as nested IF but readable
-- TRUE at the end = default (catch-all)

Combining AND and OR

=IF(AND(A2="Active", OR(B2="Gold",B2="Platinum")), "VIP", "Standard")
-- Active AND (Gold OR Platinum) = VIP

=IF(OR(AND(A2>100,B2="New"), AND(A2>500,B2="Existing")), "Bonus", "No")
-- (Over 100 AND New customer) OR (Over 500 AND Existing)

IF with ISBLANK, ISNUMBER, ISTEXT

=IF(ISBLANK(A2), "Missing", A2)
-- Show "Missing" if cell is empty

=IF(ISNUMBER(A2), A2*0.1, "Not a number")
-- Only calculate if cell contains a number

=IF(ISTEXT(A2), UPPER(A2), A2)
-- Uppercase only if cell contains text

Now practise it for real

Practice this formula yourself — type it in a real spreadsheet and get instant feedback. Free, no download needed.

Start the Excel Basics track free →

How to use IF with multiple conditionsin Excel

IF with AND — all conditions must be true

IF with OR — any condition can be true

Nested IF — multiple outcomes

IFS — cleaner than nested IF

Combining AND and OR

IF with ISBLANK, ISNUMBER, ISTEXT

Now practise it for real

How to use IF with multiple conditions
in Excel