Format currency based on condition
<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>