Round Off

Max_M

Hello all,

is it possible to round off numbers using the Formula language.

Example
0.6 -> 0

I have only found the classic rounding and the rounding to even or odd numbers.

Thanks for your help.

Sergey

Hi @Max_M

Do you need to round all the decimals to integers using the floor function? This is available by default. So this data:

first,second
0.3,0.6
1.2,2.3
3.6,3.8

will be transformed this way:

 

Max_M

Hi @sergeyd
,

this is what i needed.

Thanks a lot