Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could use floor() / and ceil() to round down/up.
- Marcus
Hi,
It can be:
Num(Div(1600000,1000000),'#.0')
Makes 1.0. Hope this helps.
Appreciated for your help, Marcus!
Simple but useful solution ^^
Thanks for your response, I have done with Marcus solution above!
=num(floor(1600000/1000000) , '#,#')