Skip to main content
Question

Question about the round formula.

  • September 22, 2021
  • 0 replies
  • 169 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------