title: Custom Rounding Function in Excel
body: <p>Let's say you have a formula that produced the following numbers:</p>
  
  <pre><code>50.77%
  24.62%
  24.62%
  </code></pre>
  
  <p>Added together they equal 100%, however they do not want the decimal places shown, and the number still visually showing they equal 100%. If you take the decimal places out you get 51% 25% 25% which actually equal 101%. </p>
  
  <p>They suggested that I put some type of formula that will round the largest decimal place up.. ie... 50.77% becomes 51%, and round the others down... if it goes over 100%, if it is still not equal to 100%, round up the next largest number until and so on until the total does equal 100%.</p>
  
  <p>Anyone know what type of formula of vba coding that I could use for this?
  I do not even know where to start.</p>