Skip to main content
1-Visitor
August 20, 2015
Solved

How to specify an incremental ceiling value without going over?

  • August 20, 2015
  • 3 replies
  • 1455 views

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.

Best answer by Fred_Kohlhepp

It's possible

3 replies

23-Emerald I
August 20, 2015

It's possible

dsochor1-VisitorAuthor
1-Visitor
August 20, 2015

Thank you Fred!

1-Visitor
August 20, 2015

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