fractions
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 |
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 |
fractions
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 |
fractions
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 |
All times are GMT +1. The time now is 12:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com