title: A method to use a formula if , and if not to tip a value manual inside, without VBA Excel
body: <p>Hello and thanks for the help in advance.</p>
  <p>Is there a way, for example, if cell A1 can say either yes or no, then I say in cell A2, if it says yes, then automatically write a word like &quot;tree&quot; in the cell, and if in cell A1 = no then the user should be able to describe/fill in the field in cell A2 manually. So far I haven't found a solution on how the formula doesn't disappear then. I don't want to use Excel-VBA here if possible. This would give me a solution, but since not everyone in my company has macro permissions, it would not be usable for everyone then..</p>