Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






Excel Math Functions : MROUND

How to use MROUND Math Functions in Microsoft Excel

Introduction to MROUND Function

MROUND function returns a number after rounding it to a given multiple. In simple words, it rounds a number to the nearest multiple of a number and while rounding, it doesn’t consider that number is greater or lower than the original number.

Download Sample file

Download Sample file for working with the tutorial.

Syntax of MROUND Function

MROUND(number, multiple)

Arguments in MROUND Function

  • number: A number to round.
  • multiple: A number for which you want to find the nearest multiple.

Notes

  • If you put zero in multiple it will return zero in the result.
  • If you skip specifying multiple it will return with an error.
  • It rounds away from zero.
  • If you have two multiples on the same distance it will return the multiple which is higher than the number you are rounding.

Tutorial of MROUND Function in MS Excel

Learn to use the MROUND Function in Microsoft Excel. Below we have shown various examples, which can help you understand the function in more practical way –

  • 12.5 rounded to 12 to the nearest multiple of 3 is 12.
  • 19 is rounded to 20 to the nearest multiple of 5
  • 13 is rounded to 12 to the nearest multiple of 6.
  • 3.6 is rounded to 2 to the nearest multiple of 4.
  • The result is 0 as I have skipped specifying multiple.
  • The result is 0 as I have specified 0 as the multiple.
  • The result is an error as I have specified -2 as multiple.
  • Here we have a tie between 20 and 18, but we get 20 as it always rounds away from zero.

Other Math Function in Microsoft Excel

Explore other math function in Microsoft excel. The list of all the math function available for everyday use is given below –

Content

Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes