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
Practice logical functions and other spreadsheet techniques through our Microsoft Office training and Excel courses in NYC. Sign up and start creating smart and efficient spreadsheets today!