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!