title: Converting a excel field from a % to a decimal in a new formula
body: <p>I have 4 different values being generated on a spreadsheet in different cells:</p>
  
  <pre><code>A=88.45%
  B=88.45%
  C=1.69%
  D=95.67%
  </code></pre>
  
  <p>I need to add these values up and divide it by 4 to get the difference from a possibility of 100%. So, the functions I've written are:</p>
  
  <pre><code>A= =SUM(1-(D6/C6))
  B= =SUM(1-(F6/C6))
  C= =SUM(I6/H6)
  D= =SUM(1-(K6/C6))
  </code></pre>
  
  <p>However, if I just have a formula that adds those cells up while they are displaying as a % and then divide it by 4 it doesn't give me the intended number which I need. The only way I've figured out to give me the accurate result was to convert them into decimals, but I'm not sure how to exactly write that. If it's even possible. I still need them displaying as a % in the original cells is the issue.</p>
  
  <pre><code>A= 0.1155
  B= 0.1155
  C= 0.0169
  D= 0.0433
  </code></pre>
  
  <p>Divide those by 4 and you get the correct 7.28%. Then I need to subtract that from 100% to generate the actual average of those 4 cells.</p>
  
  <p>Any insight?</p>