Skip to main content
Workday User Guide
Last Updated: 2023-06-23
MROUND

MROUND

Description

Returns the rounded value of the number to the multiple that you specify. If the remainder of dividing the number by the multiple is greater than or equal to half of the multiple, MROUND rounds away from 0 (up if positive; down if negative).

Syntax

MROUND(
value
,
multiple
)
  • value
    : The number to round.
  • multiple
    : The multiple to round the number to.

Example

Formula
Result
=MROUND(12.34,1)
12
=MROUND(12.34,10)
10
=MROUND(12.34,2)
12
=MROUND(-12.34,-2)
-12
=MROUND(-12.34,-1)
-12

Notes

  • value
    and
    multiple
    arguments must have the same sign.