Round off

[Newuser_qlik]

Hi All,

I need to round upward if it is less than .5 and round downward if it is greater than .5

E.g: 4.2 => 5

6.8 => 6

6.6 => 6

3.4 => 4

Need help on it.

[tresesco]

Like this?

=if(frac(vNum)*10<=5, ceil(vNum), floor(vNum))

[vinieme12]

OR below

ceil(6.2,if(frac(6.2)>=.5,-1,1))