Rounding Fractions to Nearest 1/16"

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.
 
J

JE McGimpsey

One way:

=ROUND(A1*16,0)/16

and format the cell with

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