Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
May 26, 2020 11:38 PM
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
May 27, 2020 06:03 AM
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! :slightly_smiling_face: