Thread: Rounding up to the nearest 1/8"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Rounding up to the nearest 1/8"
=CEILING(A1,1/8)
assuming that your number is in inches.
--
David Biddulph

"rudyeb" wrote in message
...
What is the formula I would write to have a result be rounded up to
the enarest 1/8"?

Thanks,


Reply With QuoteReply With Quote