Home › Functions › Math & Trig › =MROUND()
Math & Trig All versions ◉ 49 views

=MROUND()

MROUND returns a number rounded to the desired multiple. 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. The Number and Multiple arguments must have the same sign. If not, a #NUM error is returned.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=MROUND(number, multiple)
Hover argument names in the table for details.
Output typeNumber
Popularity40 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =MROUND() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download MROUND.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
number Number Required The value to round.
multiple Number Required The multiple to which you want to round number.

▣ Examples

Rounds 10 to the nearest multiple of 3. =MROUND(10, 3)
Result: 9
Rounds -10 to the nearest multiple of -3. =MROUND(-10, -3)
Result: -9
Rounds 1.3 to the nearest multiple of 0.2. =MROUND(1.3, 0.2)
Result: 1.4
Returns the #NUM! error message because -2 and 5 have different signs. =MROUND(5, -2)
Result: #NUM!

§ Remarks

  • 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.
  • The Number and Multiple arguments must have the same sign. If not, a #NUM error is returned.

✦ Tips

  • 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.

⚠ Common Errors

#NUM! If not, a #NUM error is returned.
Fix: Make the two arguments the same sign

⇄ Related Functions

=CEILING.MATH() The CEILING.MATH function rounds a number up to the nearest integer or, optionally, to the nearest multiple of significance. =FLOOR.MATH() Round a number down to the nearest integer or to the nearest multiple of significance. =INT() Rounds a number down to the nearest integer. =ROUND() The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) The result of this function is 23.78.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.