{"id":1477,"date":"2018-07-04T15:08:16","date_gmt":"2018-07-04T15:08:16","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1477"},"modified":"2023-11-03T10:09:59","modified_gmt":"2023-11-03T10:09:59","slug":"mround-function","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/","title":{"rendered":"MROUND function"},"content":{"rendered":"\n<p>The MROUND function in Excel is used to round a number to the nearest multiple of a specified value. It can be useful for tasks like rounding prices to the nearest nickel or rounding quantities to match a specific unit.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>MROUND(number, multiple)<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>number<\/strong><\/td><td>The number you want to round to the nearest multiple.<\/td><\/tr><tr><td><strong>multiple<\/strong><\/td><td>The multiple to which you want to round the number.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>The MROUND function is quite straightforward. You provide it with a number you want to round (the &#8216;number&#8217; argument) and the value to which you want to round it (the &#8216;multiple&#8217; argument). The function will then round the &#8216;number&#8217; to the nearest multiple of the &#8216;multiple&#8217; value.<\/p>\n\n\n\n<p>Here&#8217;s an example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MROUND(17, 5)<\/code><\/pre>\n\n\n\n<p>In this case, Excel will round 17 to the nearest multiple of 5, which is 15.<\/p>\n\n\n\n<p>You can also use negative numbers with the MROUND function. For instance:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MROUND(-9, 3)<\/code><\/pre>\n\n\n\n<p>Excel will round -9 to the nearest multiple of 3, which is -9 itself.<\/p>\n\n\n\n<p>If the &#8216;multiple&#8217; value is a decimal, it will still work. For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MROUND(8.75, 0.25)<\/code><\/pre>\n\n\n\n<p>Excel will round 8.75 to the nearest multiple of 0.25, which is 8.75 as well.<\/p>\n\n\n\n<p>Remember that if the &#8216;number&#8217; is equidistant between two multiples, the MROUND function will round to the nearest even multiple. For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MROUND(5, 2)<\/code><\/pre>\n\n\n\n<p>Excel will round 5 to the nearest multiple of 2, which is 6.<\/p>\n\n\n\n<p>[Optional] You can use the MROUND function in various scenarios, such as financial calculations, unit conversions, and data formatting, where rounding to specific multiples is required. This function can help you ensure that numbers align with your desired precision or format.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The MROUND function in Excel is used to round a number to the nearest multiple of a specified value. It can be useful&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MROUND function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MROUND function\" \/>\n<meta property=\"og:description\" content=\"The MROUND function in Excel is used to round a number to the nearest multiple of a specified value. It can be useful...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T15:08:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T10:09:59+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"MROUND function\",\"datePublished\":\"2018-07-04T15:08:16+00:00\",\"dateModified\":\"2023-11-03T10:09:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/\"},\"wordCount\":259,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/\",\"name\":\"MROUND function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T15:08:16+00:00\",\"dateModified\":\"2023-11-03T10:09:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/mround-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MROUND function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MROUND function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/","og_locale":"en_US","og_type":"article","og_title":"MROUND function","og_description":"The MROUND function in Excel is used to round a number to the nearest multiple of a specified value. It can be useful...","og_url":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/","article_published_time":"2018-07-04T15:08:16+00:00","article_modified_time":"2023-11-03T10:09:59+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"MROUND function","datePublished":"2018-07-04T15:08:16+00:00","dateModified":"2023-11-03T10:09:59+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/"},"wordCount":259,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/","url":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/","name":"MROUND function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T15:08:16+00:00","dateModified":"2023-11-03T10:09:59+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/mround-function\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/mround-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"MROUND function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1477"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1477"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1477\/revisions"}],"predecessor-version":[{"id":16490,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1477\/revisions\/16490"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}