Solved: Round off in Appsheet - Page 2

Boa_Casa · 05-21-2021 12:13 PM

Hi,

I wanted to understand how rounding off works in appsheet as I am facing a roadblock where if my value computed is lesser than .5 then I want it to be rounded off to nearest 5 and if it’s greater than .5 then I want it to be rounded off to nearest 0.

For eg: 4.2 to be rounded to 4.5 and 4.7 rounded to 5.

Is there a way this can be achieved?

Suvrutt_Gurjar

Or possibly

CEILING([Your Number]/0.5)*0.5

Since you are looking for rouding up to only higher 0.5 based on your shared example.

View solution in original post