Skip to main content
1-Visitor
Aug 20, 2015 7:19 PM UTC
Solved

How to specify an incremental ceiling value without going over?

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.

23-Emerald I
Aug 20, 2015 7:48 PM UTC

It's possible

3 replies

23-Emerald I
Aug 20, 2015 7:48 PM UTC

It's possible

Translate
dsochor1-VisitorAuthor
1-Visitor
Aug 20, 2015 8:21 PM UTC

Thank you Fred!

Translate
1-Visitor
Aug 20, 2015 8:41 PM UTC

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

Translate