title: Weights and Measures + 3 Significant Digits
body: <p>I am looking to create a spreadsheet that will function as a tool similar a conversion website.</p>
  
  <p>I am trying to convert units of measure (inches, feet, yards, millimeters and meters). When I input 36 inches, I need it to display the following: </p>
  
  <ul>
  <li>36 inches</li>
  <li>3 feet</li>
  <li>1 yard</li>
  <li>914 mm (technically this would be 914.4)</li>
  <li>.914 m (technically this would be 0.9144).</li>
  </ul>
  
  <p>I am trying to create a formula that will not on convert the numbers, but also break it down to show 3 significant digits (without rounding).</p>
  
  <p>For converting inches to feet I've come up with this formula:</p>
  
  <pre><code>=ROUNDDOWN((CONVERT(A7,"in","ft"))/10^(INT(LOG10(CONVERT(A7,"in","ft")))+1),3)*10^(INT(LOG10(CONVERT(A7,"in","ft")))+1)
  </code></pre>
  
  <p>This works until I hit larger numbers for example 40 inches will display as 1010 mm and I need it to display as 1016 mm. </p>
  
  <p>I have the conversion piece down, so I guess what I'm asking is how do I get it to display 3 significant digits unless the numbers is over 100, in that case everything to the right of the decimal can be dropped.</p>