Round Number to the nearest 1/8 th

I

IT-1957

I'm trying to get a number like 41.8125 to round to the nearest 1/8 ( 41.7/8
or 41.875 )
Please help.
Thank you.
 
M

Marshall Barton

IT-1957 said:
I'm trying to get a number like 41.8125 to round to the nearest 1/8 ( 41.7/8
or 41.875 )
Click to expand...


I think this does that.

Int(num * 8 + .5) / 8
 
Top