Need help to build excel logic

Hi everyone, just need some help on building logic in excel where it checks for following conditions and returns the output: In the image as shown below, I want a logic in cell A2, which will check...