title: google sheets : if cell A1 = yes, then cell A2 = 1%
body: <p>Google sheets ...</p>
  
  <p>Have a dropdown list in cell A1 ...
  dropdown list has 2 options : yes, no.</p>
  
  <p>I want to make cell A2 :
  if A1 = yes then A2 = 1% ...
  if A1 = no then A2 = 5%</p>
  
  <p>no idea how to write the formula and syntax.
  any help appreciated. </p>