Exceljet

Quick, clean, and to the point

Excel MROUND Function

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.

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.