AnsweredAssumed Answered

Ceiling every 6th number.

Question asked by gavman2000 on Nov 27, 2018
Latest reply on Nov 27, 2018 by gavman2000


Hello everyone! Got a quick question for you all that I'm kind stumped by and I can't seem to figure it out. We need to ceiling a field off every 6 which what I'm using right now is...

 

"Ceiling ( NumberExample / 6 ) * 6"

 

and that's working great, but what I would absolutely love if it would actually calculate instead of starting at 0, start at -2.

 

instead of it ceiling 97 to 102 id like it to ceiling 95 to 100 if the makes sense.

 

Any feedback or ideas would be greatly appreciated!

Outcomes