# Excel MROUND Function

Summary

The Excel MROUND function returns a number rounded to a given multiple. MROUND will round a number up or down, depending on the nearest multiple.

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**. **Number**and**multiple**must have the same sign.

Good links

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.