Presumably =IF(F10=0,0,CEILING(F10+$H$9,1/16)) ?
--
David Biddulph

"John G." wrote in message
...
Ron,

How do I meld your answer with this =IF(F10+$H$9=$H$9,0,F10+$H$9) in the
same cell?

"Ron Rosenfeld" wrote:

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