Home › Excel functions › AND, OR & NOT

AND, OR and NOT in Excel: Combine Conditions

AND, OR and NOT combine conditions into a single TRUE or FALSE. On their own they're rarely the final answer, but inside IF, filters and conditional formatting they're essential.

Excel CSE · 2 min read

Syntax

Example

• Column D: =AND(B2>=60, C2="Yes"). Only Anna meets both conditions.
• Column E: =OR(B2>=60, C2="Yes"). Everyone except Dana meets at least one.

Inside IF

Put AND or OR in the first argument of IF to return text instead of TRUE/FALSE:

A range check: is a value between 10 and 20? =AND(A2>=10, A2<=20). Note that Excel doesn't understand 10<=A2<=20; you always need AND.

NOT

NOT reverses a result. It's most useful with functions that return TRUE/FALSE:

• =NOT(ISBLANK(A2)): TRUE when A2 is filled in.
• =IF(NOT(ISNUMBER(SEARCH("test", A2))), "Real order", "Test")

Often <> is simpler: =A2<>"Done" instead of =NOT(A2="Done").

In conditional formatting and FILTER

• Conditional formatting rule: =AND($D2<TODAY(), $E2<>"Done") highlights overdue open tasks.
• FILTER doesn't accept AND/OR on ranges; use * for AND and + for OR instead: =FILTER(A2:C10, (B2:B10>=60)*(C2:C10="Yes")).