1/8ths

Tony · Aug 25, 2003

I am trying to round figures down to the nearest 1/8th and
wanted to know how I can get the formula.

Lance · Aug 25, 2003

=ROUND(E10*8,0)/8

will round to the nearest increment of .125 or 1/8

Ken Wright · Aug 25, 2003

=FLOOR(A1,0.125)