MROUND

Syntax:

MROUND ( x , multiple)

Description: Computes x rounded to multiple, away from zero. It rounds up if the remainder of dividing x by multiple is greater than or equal to half the value of multiple; otherwise, it rounds down.

Arguments:

Name

Type

Description

x

number

The value to round.

multiple

number

The multiple to which x is to be rounded.

Return Type and Value: number – x rounded to multiple.

However, if x and multiple have different signs, #NUM! is returned.

example: