Question about the round formula.
Hello guys :)
I have a field with the number 4.2 and need it to round up to 4.5.
The formula I am currently using is:
Round([field],0.5)
But it's giving me 4.0 as an answer.
I'm sure it...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
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
------------------------------
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__YouTry this
CEIL([my field], 10)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Perfect. Thx, Mark!
------------------------------
Michael Murphree
------------------------------