What if I want to round off to the nearest 10.
Let say 168.3 and the output should be 170?
What will be the formula?
Hint- Study Mahir's post and understand it. The answer should come to you.
Edit - I missed that it was nearest 10, not FLOOR.
10*round(x/10) where 'x' is your number.
Retrieving data ...