Round Values to the Nearest 5, 10, 25, or…Anything in Excel

[@ExcelSmith]

The equation in this video is similar to the MROUND function. The difference is that the equation we create in the video can round to the nearest anything (like MROUND) as well as round up or down to the nearest anything (bonus).

[@brandonrodriguez6756]

I have a table full of numbers. I want to round all the existing numbers to the nearest 5. How can I do this without adding columns?

[@ExcelSmith]

Thank you for the question. To help get you a solution, I have a quick follow-up question. Does the column that you are wanting to round to the nearest 5 contain the hardcoded values or does it contain an equation that is calculating the values based on the values of other cell(s)? Thanks.

[@huyentranthanh2935]

Saved me big time. Thank you!

[@ExcelSmith]

Thanks for the comment. I'm glad the video helped.

[@wisewitchsadvice]

Maybe the joke at the beginning was bad, but it still hooked me into the video, ngl. Good video

[@ExcelSmith]

Thanks. Glad you liked it. 😀