Formula with reference and "if"

I have a pretty simple sheet, which I would like to add a formula to, but I cannot find the right formula.    Please see the attached test-sheet.   I would like the sheet to automatically give a ...