David,

Can I nest your code with

=IF(F10+$H$9=$H$9,0,F10+$H$9) This references the cells that we want to
have rounded up values in. This simply adds a number such as 3/4" or 7/8" or
another arbitrary number to f10 for a finish size.

"David Biddulph" wrote:

Well, if you do want to be picky, try
=IF(MOD(CEILING(A1,1/16),1)=0.5,TEXT(CEILING(A1,1/16),"#
?/2"),IF(MOD(CEILING(A1,1/16),0.5)=0.25,TEXT(CEILING(A1,1/16),"#
?/4"),IF(MOD(CEILING(A1,1/16),0.25)=0.125,TEXT(CEILING(A1,1/16),"#
?/8"),TEXT(CEILING(A1,1/16),"# ?/16"))))
--
David Biddulph

"John G." wrote in message
...
I looked at that..., but if it amounts to 1/4", we want it to show 1/4",
not
4/16", that will slow down the process doing the conversion in the shop. I
know, picky, picky. :-)

John

"akphidelt" wrote:

Wouldn't the formatting to sixteenths work?

If you go to Format--Cells--Number--Fraction

Then click on As Sixteenths?

Or does that not meet your criteria?

"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?