title: Format currency based on condition
body: <p>New to Google Apps Script, but have some VBA coding experience.</p>
  
  <p>I am looking to be able to have the numeric format of a cell decided based on a different cell input.</p>
  
  <p>eg.</p>
  
  <ul>
  <li>Col A - Client Name (Validated range) </li>
  <li>Col B - Currency Type (GBP, USD, EUR - validated list)</li>
  <li>Col C - Fee  (100 - free type by user)</li>
  </ul>
  
  <p>Based on the selection in Col B it needs to put the format in col C as either:  </p>
  
  <p>£100.00 or<br>
  $100.00 or<br>
  €100.00.  </p>
  
  <p>This should be done in such a way that the "autosum" function displayed on the bottom of google sheet is still able to add the values, or if using a sumif function will result in the USD, GBP and EUR totals being correct. I.E.  it cannot be a text based solution or at least not one where this is not the result.</p>