title: is it possible to type in a cell that has a formula in it without deleting what the formula does to that cell?
body: <p>Is it possible to be able to type in a cell that already has a formula in it?</p>
  <p>I'll go into a bit more detail here</p>
  <p>The cell in question has a formula in it that when another sheet has a value typed in it is matched with the result into the said cell.</p>
  <p>Is it possible type in this cell with text but keeping the formula so when the cell is blank the formula stays and still displays the result?</p>