Functions AND – OR with Excel 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