Rounding formula problem

I need to round off a list of values ​​to 0.5
With the formula “Ceiling” they all go with the highest value, instead I need that the values ​​under 0.25 or upper 0.75 etc must go to 0.

With the “Round” formula I can’t understand where I’m wrong.
I’m using Round ({column of values}, 0.5)

Tnx in advance

Hi there @Matteo_Bersan!

This seems to be a bit more complicated than one would think. I think the below might do the trick…

IF({Input}, IF(ABS({Input} - CEILING({Input}, .5)) < ABS({Input} - FLOOR({Input}, .5)), {Input} + ABS({Input} - CEILING({Input}, .5)), {Input} - ABS({Input} - FLOOR({Input}, .5))))

This makes use of both the CEILING() and FLOOR() functions to compare which is closer to the original {Input}. I think ROUND() is looking for an integer as a precision value, where as FLOOR() and CEILING() will accept decimals.

Hope this helps! :slight_smile:

3 Likes