AnsweredAssumed Answered

Rounding

Question asked by germain on Sep 17, 2013
Latest reply on Sep 17, 2013 by davidanders

Title

Rounding

Post

     Using a formula like this one

Int(Number) + Choose(Int(Mod(Number, 1) /.25), 0, .25, .50,.75) 

How would I change it to round to the NEXT 1/8.

     example: I need to round

     23 1/16 to 23 1/8

     23 11/32 to 23 3/8 ....... and so on!

Thanks

Outcomes