fractions

[knowalittleaboutthis]

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

 

[Ron Rosenfeld]

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

 

[Sheeloo]

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

 

[Satti Charvak]

format the cell directly with:

# ??/??