Excel Function : MROUND
Math and trigonometry
Returns a number rounded to the desired multiple
Microsoft Excel Reference Page
Syntax and Description of the MROUND Excel Function
The syntax for the MROUND function in Microsoft Excel is: =MROUND(number, significance) where the number argument is the number you want to round, and the significance argument is the multiple to which you want to round the number.
About MROUND Excel Function
MROUND rounds a number to the nearest multiple of a given number. The MROUND function syntax has the following arguments: Number Required. The number you want to round. Multiple Required. The multiple to which you want to round number. For example, if you want to round the number 12.5 to the nearest multiple of 3, you would use the following formula: =MROUND(12.5,3) The result would be 15.