At my cabinetshop we need to use a couple different systems for measurement.

Some of our customers are engineer types and prefer to communicate in decimal units of measurement.  Some of them, however, can't relate to decimals values but understand inches & fractions.    Sometimes the fractional result needs to parse to a 1/16th  inch of accuracy but other times it needs to be expressed in 32nds.  So far nobody has asked about cubits but we do also need to make use of eigths, quarters & halves.

• Is there a tidy way to express decimal values with different fractional denominators?
•  For example I would like to have

2.03125 display as 2-1/32

3.0625 display as 3 -1/16

4.09375 display as 4 - 3/32

Basically I would like the decimal value I start with to intelligently recognize that when it is closer to a 32nd to display as a 32nd and to manifest as a 16th when it  the conversion is closer to that fraction.  I would like to have this parse by 32nds, 16ths, 1/8's, 1/4s etc up to one inch.

The attached file shows what I am looking for but only drills down as low as sixteenths.

Is this asking for too many denominators out of one function?

 

TEST FRACTION.fmp12.zip

Edited May 5, 201510 yr by Jarvis
add example file

Check out the Custom Functions at Brian Dunning’s site. I just did a search for Fraction and got several hits. This one is probably the one you are looking for http://www.briandunning.com/cf/55

HTH

Lee

Edited May 5, 201510 yr by Lee Smith

Thanks Lee!

​See if this helps: