You are currently viewing New Excel 2019 Function: MROUND

New Excel 2019 Function: MROUND

  • Post author:
  • Post category:Excel

MROUND Function in Excel

Every new version of Microsoft Excel comes with new or updated functions. The 2019 version of Excel is no exception. One of the new functions is MROUND.

MROUND is a little different than other rounding functions, as you reference a cell with a number and tell it to give you the closest multiple requested by you. For example, if I tell the function to give me the closest multiple of 400, then when I place a 1 in the referenced cell, it will give me a zero. However, if I place 300 in the referenced cell, the function will populate a 400. If I place 500 in the referenced cell, I will get 400 as well; but if I place 700 in the referenced cell, I will get 800.

Check out this video to see how to set up the function and see how it works:

Learn more ways that Excel can make your work easier by taking an Excel training as a private group at your company or as an individual in our virtual Training Center with AdvantEdge Training.