Excel Function

MROUND

Rounds number to nearest specified multiple.

MROUND(number, multiple)

Arguments

number

Required

Specify a single cell reference.

multiple

Required

Enter a numeric value.

Practice Preview

display numeric calculation results. Use MROUND to Rounds number to nearest specified multiple. use 10 for multiple. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=MROUND(D2, 10)

Practice This Function