MROUND

Round a number to the nearest specified multiple

Related Functions

Sponsored Link

MROUND

Purpose 

Round a number to the nearest specified multiple

Return value 

A rounded number.

Syntax 

=MROUND (number, multiple)

Arguments 

  • number - The number that should be rounded.
  • multiple - The multiple to use when rounding.

Usage notes 

MROUND rounds up, away from zero.

The rounding occurs when the remainder left from dividing number by multiple is greater than or equal to half the value of multiple.

Sponsored Link

0 votes. 0 / 5