Help with formula (decimal to fraction)

[Jack Deuce]

I'd like to be able to convert decimal to fraction of an inch. IOW I
have calculated, from the circumference, the diameter (d=c/3.14) and
would like to show the actual inches instead of the decimal
equivalent. 6.250 decimal would display 6 1/4, 6.375 decimal would
display 6 3/8.

Thanks in advance

 

[Ron Rosenfeld]

I'd like to be able to convert decimal to fraction of an inch. IOW I
have calculated, from the circumference, the diameter (d=c/3.14) and
would like to show the actual inches instead of the decimal
equivalent. 6.250 decimal would display 6 1/4, 6.375 decimal would
display 6 3/8.

Thanks in advance

If you want the result to display to the closest 1/8, but to show as 1/4 3/8
etc., you should ROUND to the nearest 1/8 and then select a format that shows
at least one digit. (2 digits if you want to round to 1/16 1/32 or 1/64)

So with your circumference in A1, somehting like:

=ROUND(A1/PI()*8,0)/8

or

=MROUND(A1/PI(),1/8) (requires ATP or Excel 2007+)

For 16ths:

=ROUND(A1/PI()*16,0)/16
--ron

 

[David Biddulph]

The answer hasn't changed since when you asked the same question the
previous day.