All lessons
LogicintermediatePro

AND & OR

Combine multiple conditions into one TRUE/FALSE test — AND requires every condition to pass, OR only needs one.

Read the full guide to Logical Operators in Excel (AND, OR, NOT) →

AND & OR is a Pro lesson

Upgrade to Pro to unlock this lesson and every other lesson on Excel Practice Lab.

See Pro plans