Geek Answers Handbook

Rounding the value to the nearest 50

I want to round the values ​​to the nearest 50. Eg.

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 tried the following functions ...

 =FLOOR(C629,50) =FLOOR((C629+50),50) =CEILING(C631,50)

But I'm still not getting the results as expected.

+4
source share
2 answers

From the examples you cited, it seems like you want to move each number to the nearest multiple of 50.

This function should do the following:

 =ROUND(C629 / 50 , 0) * 50

This works as follows for 129 :

  • 129/50 = 2.58
  • ROUND (2.58, 0) = 3
  • 3 * 50 = 150

EDIT: An OP comment for using inline MROUND is a much better idea.

+5
source

For clarity, the simplest answer is: MROUND , for example:

 =MROUND(589,50)

This decision was presented in a comment by shantanuo .

+1
source

More articles:


All Articles