{"id":805,"date":"2019-04-19T13:54:11","date_gmt":"2019-04-19T10:54:11","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=805"},"modified":"2019-04-19T13:57:38","modified_gmt":"2019-04-19T10:57:38","slug":"the-mround-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-mround-function\/","title":{"rendered":"The MROUND Function"},"content":{"rendered":"\n

It rounds a number to a specific multiple.<\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

MROUND<\/strong>(number<\/strong>, multiple<\/b><\/span><\/em>) <\/p>number<\/strong><\/b><\/span>: <\/strong>The number you want to round.
multiple<\/strong>: The multiple to which you want to round the number<\/strong>.<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n

The number and multiple arguments must have the same sign. If not, a #NUM error is returned <\/p>\n\n\n\n

To always round up, use the ROUNDUP <\/a><\/strong>function.<\/p>\n\n\n\n

To always round down, use the ROUNDDOWN <\/a><\/strong>function.<\/p>\n\n\n\n

To round a number to a specified number of digits, use the ROUND <\/a><\/strong>function.<\/p>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the MROUND function:<\/strong><\/p>\n\n\n\n

In the cell \u03911 insert the number \u03c0 using the proper function. Then, in the cell B1, round the value of the cell A1 to the nearest multiple of 0.2<\/p>\n\n\n\n

\n