How to round down to the nearest 50?

I want to round down to the nearest multiple of 50 in Excel.

So if cell A1 = 318, I want to round it down in cell B1 to 300, and if A1 = 367, round down to 350.

Is this possible?

If so how?

1

2 Answers

The rounding functions work at the place level. You could use:

=50*INT(A1/50)

However, Ron Rosenfeld's answer is simpler.

If you wanted to round to a multiple instead of rounding down, you could use MROUND:

=MROUND(A1,50)

You can also use the FLOOR function

=FLOOR(A1,50)

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy