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.
This is how I have been achieving rounding DOWN to the nearest increment using INT, and I use ROUND to round UP.
=( int((int("target value to round"))/10))*10
In this case it is rounding DOWN to nearest "10". To round down to nearest "5" just change the 10 in two places to 5 eg.
=( int((int("target value to round"))/5))*5
To round UP to nearest increment substitute "INT" with "ROUND"
=( round((round("target value to round"))/10))*10
Retrieving data ...