## Forum Discussion

MarkShnier__You

Qrew Legend

np,

use the Ceiling function

Ceil([field],0.5)

The opposite would be Floor([field],0.5) to always round down.

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------

use the Ceiling function

Ceil([field],0.5)

The opposite would be Floor([field],0.5) to always round down.

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------

MichaelMurphree

3 years agoQrew Member

Similiar question, I think, but I can't figure it out.

We have services that we bill in "lots" of 10. So if you need 6 of it, we bill for a quantity of 10. If you need 11 of them, we bill for a quantity of 20.

Any help on rounding to 10's instead of the next integer?

------------------------------

Michael Murphree

------------------------------

We have services that we bill in "lots" of 10. So if you need 6 of it, we bill for a quantity of 10. If you need 11 of them, we bill for a quantity of 20.

Any help on rounding to 10's instead of the next integer?

------------------------------

Michael Murphree

------------------------------

- MarkShnier__You3 years agoQrew LegendTry this

CEIL([my field], 10)

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------- MichaelMurphree3 years agoQrew MemberPerfect. Thx, Mark!

------------------------------

Michael Murphree

------------------------------