On Thu, 8 May 2008 18:58:29 +0100, "David Biddulph" <groups [at]
biddulph.org.uk 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

Might be simpler to just use:

=CEILING(A2,1/16)

and then custom format the cell as # ??/??
--ron