In this tutorial, I demonstrate how to use the “Logical Functions” of IF, AND, and OR in Excel. In order to return the answer TRUE with the AND Function, each logical test must answer TRUE.
I frequently “Nest” the AND Function inside an IF Function and I demonstrate how this works.
I also share my “Best Practice” tips for using the Advanced Filter tool in Excel. The key to success is know how to use AND criteria and OR criteria.
I invite you to visit my website – www.thecompanyrocks.com – to view all of my videos and to sample the many resources that I offer.
The Company Rocks
Duration : 0:11:13