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!