## Forum Discussion

MichaelMurphree

Qrew 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__You

3 years agoQrew Legend

Try this

CEIL([my field], 10)

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

Mark Shnier (YQC)

mark.shnier@gmail.com

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

CEIL([my field], 10)

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

Mark Shnier (YQC)

mark.shnier@gmail.com

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

- MichaelMurphree3 years agoQrew MemberPerfect. Thx, Mark!

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

Michael Murphree

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