G Guest May 29, 2007 #1 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.
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 May 29, 2007 #3 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
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