title: Excel function that returns the closest number to zero without rounding
body: <p>I need a function that returns the closest value to zero from from a range e.g A1 - A10. </p>
  
  <p>I have found solutions for this on other websites however the value that is returned is rounded to no decimal places.</p>
  
  <p>For my purposes I need the closest value to zero that retains up to ten decimal places.</p>
  
  <p>I have tried the formula:</p>
  
  <pre><code>=INDEX(A1:A15,MATCH(SMALL(INDEX(ABS(A1:A15),0,1),COUNTIF(A1:A15,0)+1),INDEX(ABS(A1:A15),0,1),0))
  </code></pre>
  
  <p>however, If say the closest value is -1.0896 It will return -1 not -1.0896</p>
  
  <p>I have a vba procedure changing the values in the range. so a vba solution that saves the closest value to zero to a variable would work.</p>