MROUND()

Syntax. MROUND(number,multiple)

Definition. This function returns a number rounded to a multiple.

Arguments

• number (required) The value to round

• multiple (required) The multiple to which you want to round number

Background. The MROUND() function allows you to round a number to the multiple of a given value. MROUND() rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple. If the number is less than or equal to half of the multiple, the number is rounded down.

Examples. All sales prices in a store have to be divisible by 0.05—for example: $10.05, $11.10, $15.25, or $20.00.

• =MROUND(12.31,0.05) returns $12.35.

• =MROUND(0.32,0.05) returns $0.30.

• =MROUND(1.24,0.05) returns $1.25.

See Also

CEILING(), EVEN(), FLOOR(), ODD(), ROUND(), ROUNDDOWN(), ROUNDUP(), TRUNC()

Sample Files

Use the ROUND worksheet in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.