Thread: fractions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default fractions

On Mon, 17 Nov 2008 18:24:01 -0800, knowalittleaboutthis
wrote:

I am trying to make a fraction out of a decimal. I need to round up the
decimal to the nearest 1/8" exanple .251 should come out to be 3/8" any
suggestions



=CEILING(A10,1/8)

Then custom format like # ?/?
--ron