fx =IF(AND(A1>50,B1="Active"),"Yes","No")ABCOrder #1042$1,250ApprovedOrder #1043$450ReviewOrder #1044$3,200Approved
🔀 Logic

AND / OR Formula for Logic

Check if multiple conditions are true. Copy-paste ready for Excel, Google Sheets, and Airtable.

=IF(AND(A1>50,B1="Active"),"Yes","No")
When you need this: When you need to mark rows where BOTH conditions exist: score > 50 (A1) AND status = "Active" (B1).

How it works

  1. 1AND returns TRUE only if ALL conditions are true (requires multiple true conditions).
  2. 2OR returns TRUE if AT LEAST ONE condition is true.
  3. 3Use inside IF to create multi-criteria logic.

Variations

OR condition example
=IF(OR(A1="North",A1="East"),"Show","Hide")
Complex AND/OR logic
=IF(AND(A1>50,OR(B1="Active",B1="Pending")),"Yes","No")

Related Formulas

IF — Return different values based on a conditionLogicIFS — Check multiple conditions (cleaner than nested IF)LogicIFERROR — Show a custom value instead of an errorLogicCHOOSE — Return value based on index numberLogic

Need a formula that's not here?

Generate custom formula →