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

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

See http://www.cpearson.com/excel/FractionalArithmetic.aspx for the solution
to your problem.

"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

format the cell directly with:

# ??/??

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"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