asterisk-solid Classes available in-person (strict social distancing) or live online with an extended free retake period. See details.

Hero image for Excel And & Or Tutorial

Excel And & Or Tutorial

Microsoft Excel Free Tips & Tutorials

Learn to use the And and Or functions to test whether multiple conditions are true, or not true.

A Quick Example

=AND(Logical Test1, [Logical Test2], …)

  • All logical tests must be true

=OR(Logical Test1, [Logical Test2], …)

  • At least one logical test must be true

Learn More About Excel

Learn all the tips and tricks of Excel through our Microsoft Office training and Excel courses in NYC. Sign up and start creating smart and efficient spreadsheets today!