fraction round offs

[kirk]

I set my fraction read out to be 8/16
So if I type in 3/4 or .75 it reads out 12/16.
I would rather this reads out as 3/4.
but if I change the format it rounds up to the nearest
1/8 or whatever I change the format. It seems like it
would change

 

[Dave Peterson]

You can set the format to be "up to xx digits" or fix the denominator to a
specific value.

if you used up to 2 digits, then 8/16 would show as 1/2. 10/16=5/8,
13/16=13/16.

I'm not quite sure what you really want, but if you wanted no more that 16ths,
but always reduced to its lowest form, you may want to look at David McRitchie's
site:

http://www.mvps.org/dmcritchie/excel/formula.htm
Look for:
Conversions of Feet and Inches, decimal to 1/16th inch fractional measurements

It has some formulas written by Bernie Dietrick that you may like.

 

[Earl Kiosterud]

Kirk,

Hmmm. I just tried .75 and =3/4 formatting it as "up to two digits (21/25)
and it displayed 3/4. Tried it on XLXP on WinXP and XL97 on Win98.

 

[Ron Rosenfeld]

I set my fraction read out to be 8/16
So if I type in 3/4 or .75 it reads out 12/16.
I would rather this reads out as 3/4.
but if I change the format it rounds up to the nearest
1/8 or whatever I change the format. It seems like it
would change

If you want your answer displayed to the nearest sixteenth, and fractions
reduced, then you have to round your result.

A formula for rounding a number to the nearest 16th is:

=ROUND(num*16,0)/16

If you then format the cell for "up to two digits" your result will display to
the nearest 16th reduced to the minimum common denominator. So something like
33/64 would be rounded to 0.5 and displayed as 1/2.


--ron