I cannot figure out the code for Excel for these statements

Can someone tell what what if statements this problem is trying to solve and maybe help me with the first row so I can do the rest please?

https://www.dropbox.com/s/3mqgd6567pb34hx/54268141556__1219E4DC-7CB3-4D64-837E-8E8CC92CD756.jpg?dl=0