Not in the same cell, but =CEILING(A7,1/16) and format as # ??/16
--
David Biddulph

"John G." wrote in message
...
I have cells formatted as fraction, up two digits. We are a mfg. company
cutting metal and if it is not on a tape measure, we don't use it. If we
input in an odd decimal value, we can get stuff like 17/20 or other wierd
unusable fractions. Is there a way to have the same cell of input to show
a
result rounded up to the absolute nearest 1/16th of an inch?