On Thu, 2 Jul 2009 11:15:01 -0700, jct6641
wrote:

When converting a decimal to a fraction, I get some responses like 1/67 when
what I am looking for is increments of 1/64. Then I want to display 10/64 as
5/16 or 32/64 as 1/2 etc.
Can this be accomplished in an excel formula or combination of nested
formulas?

Round the result to the nearest 64th;
Format the cell as a fraction with up to two digits.

And yes, it will display just a single digit when appropriate.

To Round the result:

=ROUND(A1*64,0)/64

Or =ROUND((Your_Formula)*64,0)/64

Or =mround(a1,1/64)



--ron