I want to round values to its nearest 50. For e.g.
121 should get rounded to 100
129 should get rounded to 150
178 should get rounded to 200
165 should get rounded to 150
I have tried the following functions...
=FLOOR(C629,50)
=FLOOR((C629+50),50)
=CEILING(C631,50)
But I am still not getting the results as expected.