Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 01-07-2009
Member
 
Join Date: Oct 2008
Posts: 65
How to convert fractional inches into rounding numbers

I design using fractional inches with a precision of 1/16th of an inch, but the problem is that i can't calculate that after 5 precision number, so i wanted to have something in hand that would give me the best possible answer, because when I dimension, I use fractional inches with the same precision. My work is checked occasionally with decimal inches with a precision of to (0.0000).
Reply With Quote
  #2  
Old 01-07-2009
Member
 
Join Date: Apr 2008
Posts: 193
Re: How to convert fractional inches into rounding numbers

I will suggest you to use the same format for your calculation as suggested above. Or else you may make use of any one of the scientific calculator.

=INT(A1)&"'--"&IF(INT(ROUND(MOD(A1,1)*12*4,0)/4)=
ROUND(MOD(A1,1)*12*4,0)/4,TEXT(ROUND(MOD(A1,1)*
12*4,0)/4,"#0\"""),TEXT(ROUND(MOD(A1,1)*12*4,0)/4,"# ?/?\"""))

BoardCalc is a Palm OS calculator which is specifically for woodworkers. It ?thinks? in fractions, feet and inches, board feet, or metric as needed. It does conversions between metric and imperial units, decimal and fractions, board feet and areas/volumes, and helps those of us who stumble a little.
Reply With Quote
  #3  
Old 01-07-2009
Member
 
Join Date: Jan 2009
Posts: 140
Re: How to convert fractional inches into rounding numbers

Converting decimals into feet, inches and fractions of an inch, is a simple procedure and it can be applied to many different skill levels. The dimension precision corrects the display but not the underlying variation in actual distances. I run into this all the time with the others I work with. Most of them work in a pre-cad mode, using CAD as a means of pencil drafting on screen.I guess it is possible in a macro. It always seems inelegant to have to calculate something more than once. Their solution to most issues of this type is to override rather than repair the problem.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to convert fractional inches into rounding numbers"
Thread Thread Starter Forum Replies Last Post
How to convert words into numbers in MS Excel 2010 spreadsheet K@ttY Windows Software 8 07-01-2012 09:37 AM
32 inches 1080p HDTV vs 30 inches 2560x1600 monitor Alibamu Monitor & Video Cards 5 28-09-2010 11:55 AM
How to convert centimeter into feets and inches Amie Software Development 3 02-09-2009 06:07 PM
Convert ruler, etc. from metric to inches in Office 2007 ... LAMONT D Office Setup 2 17-08-2009 06:23 PM
How to use vlookup for rounding up numbers in Excel 2003 AK_Chopra Windows Software 3 06-06-2009 09:08 PM


All times are GMT +5.5. The time now is 03:07 AM.