title: how to determine the accuracy of a number in vba? How many decimal places does a number have?
body: <p>I need a way to tell how accurate a number is. For example If I had x=3.14, I need to write code that can tell that 3.14 is accurate up to the 1 one-hundreths. Or if I had x= 31300, I would need to know that x was accurate only to the hundreds place? </p>
  
  <p>EDIT: Maybe accurate was a poor choice of word. I'm using a Bisection algorithm to find the root of a polynomial that I've fit to some x,y coordinates. I need to provide an degree of accuracy (DOA) that tells the algorithm when it has gotten close enough to the actual root to stop. So if the data is given as 12.1, I would want my DOA to be +/- 0.01.</p>