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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks