On Thu, 8 May 2008 09:25:03 -0700, John G.
wrote:

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?

I'm not sure what you mean by "rounded up to the absolute nearest 1/16th of an
inch". Rounding UP does not necessarily go to the *nearest* 1/16th. For
example, 1/16 + 1/64 would ROUND to 1/16 but would ROUNDUP to 2/16 (or 1/8).

Either can be done in the cell of input, using a macro, but you need to decide
which you want, and also whether it is OK to actually change the value that you
have inputted to be rounded, or rounded up, to the appropriate 16th.

Finally, you won't be able to ROUNDUP in the cell of input and NOT change the
inputted value.
--ron