ChechoNajera
Qrew Member
3 years ago

# 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's a very simple solution, but I can't figure it out.

Any tips/help? Thanks!

------------------------------
Checho Najera
------------------------------

### 5 Replies

• 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
------------------------------
• Thank you so much Mark! This worked perfect.

------------------------------
Checho Najera
------------------------------
• 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
------------------------------
• Try this
CEIL([my field], 10)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------