How to round in nearest 1/8

[archrid404]

On the panel order form, where it shows the drill spacing, can we have the sizes rounded to the nearest 1/8".  

i.e.   For an 99" opening where we've determined the drill spacing to be 11.375" or 11 3/8", it should be shown

as  4" - 15 3/8" - 26 3/4" - 38 1/8" - 49 1/2" - 60 7/8" - 72 1/4" - 83 5/8" - 95" - 99"

[comment]

40 minutes ago, archrid404 said:

On the panel order form, where it shows the drill spacing,

You assume we know what you're talking about. I don't.

 

In general, if your input is a decimal number, you can round it to the nearest 1/8 by doing =

Round ( Input * 8 ; 0 ) / 8

 

 

If you want the result to be formatted as fraction, try =

Let ( [
num = Round ( Input * 8 ; 0 ) / 8 ;
eights = Mod ( num ; 1 ) * 8
] ;
Trim ( 
If ( Int ( num ) or not eights ;  Int ( num ) )
&
Choose ( eights ; "" ; " 1/8" ; " 1/4" ; " 3/8" ; " 1/2" ; " 5/8" ; " 3/4" ; " 7/8" ) 
)
)

 

--
Note that you can use fraction symbols ⅛, ¼, ⅜, ½, ⅝, ¾, ⅞ instead of regular digits.