fractional display

I need to be able to convert a decimal value to a fractional value. The accuracy of the display rounded up to the next 32nd, but I want the value simplified as well
ie: .451 = 15/32 and 4/32 = 1/8

pdelnet

=MROUND(A1, 1/32) and format as Fraction (up to 2 digits)

Requires the Analysis ToolPak. To do it without, use

=ROUND(A1*32, 0) / 32

=MROUND(A1, 1/32) and format as Fraction (up to 2 digits)

Requires the Analysis ToolPak. To do it without, use

=ROUND(A1*32, 0) / 32



These do not do the round up to the next 1/32 value,

I have used-

=((ROUNDUP(((K17-INT(K17))*32),0))/32)+(INT(K17))

there must be a much more elegant way.

Oh, you did say round UP, sorry.

=ROUNDUP(A5*32, 0) / 32