title: Excel: Adjacent Cells
body: <p>How do I use the IF command, or another in adjacent cells? Example, if <code>A1 = 'knife'</code> and the adjacent cell (A2) is equal to 'fork'. That is, I need to identify an adjacent cell in the vertical direction.
  <img src="https://i.stack.imgur.com/oPx9v.png" alt="enter image description here"></p>