How to specify an incremental ceiling value without going over?

[dsochor]

Is it possible in Mathcad to write a function that provides the nearest multiple of a value without going over a particular ceiling? For example, I have a maximum allowable bolt Ø of 0.33in. Bolts come in 0.125in (1/8in) Ø increments. I'd like Mathcad to provide me with a 0.25in Ø bolt size (as 0.375in exceeds 0.33in). I tried Ceil(0.33in,0.125in) but the result is 0.375in.

[Fred_Kohlhepp · Accepted solution]

It's possible

[dsochor]

Thank you Fred!

[MJG]

Not sure what Fred's worksheet contains, but if you replace "Ceil" with "Floor", I think you'll get the results you want.