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)

Round Down to the nearest multiple	3	Jan 27, 2010
Formula converts value into Feet, Inches & Fraction of an Inch	6	Aug 28, 2008
rounding down to nearest 1/32	3	Dec 8, 2009
Formula Help	2	Feb 2, 2010
Average rounded to nearest 0.50	4	Aug 31, 2009
rounding up to nearest specified whole number	1	Dec 31, 2008
Formula converts a value to Feet Inches and fractions of an inch	1	Oct 8, 2008
Round time to nearest 15 minutes in decimal format	4	Sep 23, 2009

Ask a Question