Jump to content

How to round in nearest 1/8


This topic is 1605 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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"

Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

This topic is 1605 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.