asterisk-solid Courses currently offered live online. In-person also available soon. Learn More.

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!