title: Change value in a cell based on value in another cell
body: <p>Searched for this but could not find a way to do it.</p>
  
  <p>I would like to be able to transform a value in one cell to another value in a different cell like this:  </p>
  
  <p>When cells in Column <code>A</code> contain <code>Y</code> set same number cells in Column <code>B</code> to <code>Male</code> or when cells in Column <code>A</code> contains <code>N</code> set same number cells in Column <code>B</code> value to <code>Female</code>.</p>
  
  <p>For instance:</p>
  
  <pre><code>A2 = Y then B2 = Male
  A2 = N then B2 = Female
  </code></pre>