Question about the round formula.

Question

Hello guys :)&nbsp;
I have a field with the number 4.2 and need it to round up to 4.5.&nbsp;
The formula I am currently using is:&nbsp;
Round([field],0.5)
But it's giving me 4.0 as an answer.&nbsp;
I'm sure it's a very simple solution, but I can't figure it out.&nbsp;
Any tips/help? Thanks!&nbsp;------------------------------Checho Najera------------------------------

markshnier__you · Answer

np,use the Ceiling functionCeil([field],0.5)The opposite would be Floor([field],0.5) to always round down.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

chechonajera · Answer

Thank you so much Mark! This worked perfect.------------------------------Checho Najera------------------------------

michaelmurphree · Answer

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

markshnier__you · Answer

Try thisCEIL([my field], 10)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

michaelmurphree · Answer

Perfect.&nbsp; Thx, Mark!------------------------------Michael Murphree------------------------------

Forum Discussion

Question about the round formula.