The functions AND or OR are very useful if you have to create a test on more than 1 criteria. Have a look at the examples in this article
Permanent link to this article: https://www.excel-exercise.com/function-and-or/
Frédéric LE GUEN
Web design : Isidore, le majordome du Net
Made with by Graphene Themes.