As we know, we can round the Million to 2 digits by :
num(1600000/1000000 , '#,#') = 1.6
num(1600000/1000000 , '#,0') = 2.0
Any method or function that can make this to 1.0 ?
xxx(1600000/1000000, 'xxx') = 1.0
xxx(1600000, 'xxx') = 1000000
Thanks and best regards,
You could use floor() / and ceil() to round down/up.
Appreciated for your help, Marcus!
Simple but useful solution ^^
It can be:
Makes 1.0. Hope this helps.
Thanks for your response, I have done with Marcus solution above!
=num(floor(1600000/1000000) , '#,#')
Retrieving data ...