Function XOR The function XOR is a logical function to find exclusive OR. That's mean one and only one result (and not TRUE for both)
Functions AND – OR 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