Excel Forum
Similar Content
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel.  This includes Ex...
Change Formulas to Absolute or Relative References
Macro: This macro will change the formulas in cells to absolute or relative. It allows you to cha...



Excel Magic Trick #237: ROUND to Digit or Multiple


Learn how to use the functions MROUND, CEILING, FLOOR, ROUND, ROUNDUP, ROUNDDOWN to round exactly how you would like.
See how to round to a specific digit or to a specified amount or multiple.
Standard Rounding Rules: 1) select position you want to round to; 2) look 1 to the right and if that is 5 or greater, add 1; if it is 4 or less, don't add 1; then remove all other digits.
The ROUND function follows the standard rounding rules and rounds to a specified digit
The ROUNDUP function always rounds up to a specified digit
The ROUNDDOWN function always rounds down to a specified digit
The MROUND function follows the standard rounding rules and rounds to a specified amount (multiple)
If you are using Excel 2003 you must add the analysis toolpak to get the MROUND function (2007 has it). To add this, go to Tools, Addins, and check the Analysis Toolpak.
The CEILING function always rounds up to a specified amount (multiple)
The FLOOR function always rounds down to a specified amount (multiple)





Got a Question? Ask it Here in the Forum.