Round to Multiple [MROUND]

Rounds the given number to the desired multiple.

Syntax

MROUND (Number, Multiple)

Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.

Data Types of the Arguments

Integer, Number, Length, Area, Volume, Angle (Must be identical for all Arguments)

Data Type of the Result

Depends on Arguments’ Data Type

Expression

MROUND (2567, 10)

Result

2670

Notes

If the remainder is greater than or equal to half of the multiple, then MROUND rounds up.

To always round up to a certain multiple, use Round Up to Multiple [MROUNDUP].

To always round down to a certain multiple, use Round Down to Multiple [MROUNDDOWN].

To round numbers to specific decimal places: use Round [ROUND], Round Up [ROUNDUP], Round Down [ROUNDDOWN].

  • Was this Helpful ?
  • YesNo
Relevant topics
Round [ROUND]
Rounds a number to a specified number of digits. Syntax ROUND (Number, NumberOfDigits) Note: The required separator (comma or ...
Round Up to Multiple [MROUNDUP]
Rounds the given number up to the desired multiple. Syntax MROUNDUP (Number, Multiple) Note: The required separator (comma or ...