You can set your conditions to test for specific text, as I have done in this example withB2="Yes", just put the text you want to check between inverted comas “ ”. Alternatively you can test for a number and because the AND and OR functions belong to the logic family, you can em...