Rounding Fractions to Nearest 1/16"

  • Thread starter Thread starter mystng505
  • Start date Start date
M

mystng505

I was wondering if there was an easy way to convert the fractions
created by the formulas into the nearest 1/16" and then reduce it down
to the lowest common denominator. ie: 4/16" to 1/4" I am using
version excell 2000.
 
One way:

=ROUND(A1*16,0)/16

and format the cell with

Format/Cells/Number/Custom # ??/??
 
Back
Top