Ron,

I have taken everything that you have suggested and came up with a solution
that works just fine. Thank goodness we aren't going to the moon on my work
here. We make storefront or window framing here, and we have a plus minus of
1/8". So rounding up to another 16th of inch will not really hurt us. What it
does is keeps us covered on the plus side for material amounts and costs.
Better to be a tad up that low. We can always take some away, but adding on
when not budgeted can be problematic. Thanks for all your help. I should have
posted in the newbie area.

John

"Ron Rosenfeld" wrote:

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