How do I use MROUND in Excel?
Use MROUND when you want to round to a chosen multiple. Enter Number, Multiple in that order, then add optional arguments when needed.
Excel Function
MROUND
Rounds number to nearest specified multiple.
MROUND(number, multiple)Arguments
number
RequiredSpecify a single cell reference.
multiple
RequiredEnter a numeric value.
Practice Preview
Use MROUND to return the result with these settings (Number: D2 (cell D2 (Amount in column D)), Multiple: 10).
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=MROUND(D2, 10)Result
360
Practice This Function
MROUND FAQ
Where can I practice MROUND?
Use the "Start Function Practice" button to jump straight into MROUND drills.
What arguments does MROUND use?
The main arguments are Number, Multiple. Enter them in order.