title: Excel Formula IF statement, make cell blank when other cell has value
body: <p>I have a sheet in Excel of which I want to check if a cell has been filled in with the string "x". If the value is "x" then I want the value in the cell of the formula to be empty/null.
  So what I did was:</p>
  
  <pre><code>=IF(E5="x", "", "")
  </code></pre>
  
  <p>Now, when I hit enter, it says that there is a problem found with the formula and highlights the '"x",' part. How can I resolve this issue? I do not want to use vba!</p>