Rounded value (1.6 become 1.0)

[#1]

Dear Community,

As we know, we can round the Million to 2 digits by :

num(1600000/1000000 , '#,#') =  1.6

or

num(1600000/1000000 , '#,0') = 2.0

Any method or function that can make this to 1.0 ?

For example:

xxx(1600000/1000000, 'xxx') = 1.0

or

xxx(1600000, 'xxx') = 1000000

Thanks and best regards,

Chanel

[marcus_sommer · Accepted solution]

You could use floor() / and ceil() to round down/up.

- Marcus

[#3]

Hi,

It can be:

Num(Div(1600000,1000000),'#.0')

Makes 1.0. Hope this helps.

[#4]

Appreciated for your help, Marcus!

Simple but useful solution ^^

[#5]

Thanks for your response, I have done with Marcus solution above!

=num(floor(1600000/1000000) , '#,#')