{"id":2114,"date":"2023-10-15T11:45:18","date_gmt":"2023-10-15T11:45:18","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/mround\/"},"modified":"2023-12-10T06:25:13","modified_gmt":"2023-12-10T06:25:13","slug":"mround","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/mround\/","title":{"rendered":"Come utilizzare la funzione mround in excel?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-315386357\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>MROUND <strong>restituisce un numero dopo averlo arrotondato a un dato multiplo<\/strong> . In termini semplici, arrotonda un numero al multiplo pi\u00f9 vicino di un numero e durante l&#8217;arrotondamento non considera quel numero maggiore o minore del numero originale. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72731\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"funzione mround\" width=\"471\" height=\"171\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Sintassi<\/h2><p> MROUND(numero, multiplo)<\/p><h2 class=\"wp-block-heading\"> argomenti<\/h2><ul><li> <strong>numero<\/strong> : un numero che vuoi arrotondare.<\/li><li> <strong>multiplo<\/strong> : un numero di cui si desidera trovare il multiplo pi\u00f9 vicino.<\/li><\/ul><h2 class=\"wp-block-heading\"> Esempio<\/h2><p> Nell&#8217;esempio seguente, abbiamo utilizzato argomenti diversi nella funzione MROUND con il multiplo diverso pi\u00f9 vicino per arrotondare il numero. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72732\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-mtour-avec-differents-multiples-les-plus-proches.png\" sizes=\"auto, \" srcset=\"\" alt=\"rosolato con multipli diversi pi\u00f9 vicini\" width=\"581\" height=\"416\"><\/figure><\/div><ol type=\"1\"><li> 12,5 arrotondato a 12 al multiplo di 3 pi\u00f9 vicino \u00e8 12.<\/li><li> 19 viene arrotondato a 20 al multiplo di 5 pi\u00f9 vicino<\/li><li> 13 viene arrotondato a 12 al multiplo di 6 pi\u00f9 vicino.<\/li><li> 3,6 viene arrotondato a 2 al multiplo di 4 pi\u00f9 vicino.<\/li><li> Il risultato \u00e8 0 perch\u00e9 ho saltato la specifica di multipli.<\/li><li> Il risultato \u00e8 0 perch\u00e9 ho specificato 0 come multiplo.<\/li><li> Il risultato \u00e8 un errore perch\u00e9 ho specificato -2 come multiplo.<\/li><li> Qui abbiamo un pareggio tra 20 e 18, ma otteniamo 20 perch\u00e9 l&#8217;arrotondamento avviene sempre da zero.<\/li><\/ol><h2 class=\"wp-block-heading\"> Punti importanti<\/h2><ol type=\"1\"><li> Se usi uno zero negli argomenti multipli, restituir\u00e0 zero nel risultato.<\/li><li> Senza specificare pi\u00f9 argomenti verr\u00e0 restituito un errore nel risultato.<\/li><li> Arrotonda sempre da zero se ci sono due multipli pi\u00f9 vicini. Ci\u00f2 significa che se hai due multipli entro la stessa distanza, restituir\u00e0 il multiplo maggiore del numero che stai arrotondando (vedi Esempio 8 per riferimento).<\/li><\/ol>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2114","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Come utilizzare la funzione MROUND in Excel? (esempio)<\/title>\n<meta name=\"description\" content=\"Un tutorial semplice e veloce per imparare a utilizzare la funzione MROUND in Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/it\/mround\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come utilizzare la funzione MROUND in Excel? (esempio)\" \/>\n<meta property=\"og:description\" content=\"Un tutorial semplice e veloce per imparare a utilizzare la funzione MROUND in Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/mround\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:25:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/mround\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/mround\/\",\"name\":\"Come utilizzare la funzione MROUND in Excel? (esempio)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/mround\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/mround\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png\",\"datePublished\":\"2023-10-15T11:45:18+00:00\",\"dateModified\":\"2023-12-10T06:25:13+00:00\",\"description\":\"Un tutorial semplice e veloce per imparare a utilizzare la funzione MROUND in Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/mround\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/mround\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/mround\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/mround\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come utilizzare la funzione mround in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come utilizzare la funzione MROUND in Excel? (esempio)","description":"Un tutorial semplice e veloce per imparare a utilizzare la funzione MROUND in Excel.","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:\/\/exceladvisor.org\/it\/mround\/","og_locale":"it_IT","og_type":"article","og_title":"Come utilizzare la funzione MROUND in Excel? (esempio)","og_description":"Un tutorial semplice e veloce per imparare a utilizzare la funzione MROUND in Excel.","og_url":"https:\/\/exceladvisor.org\/it\/mround\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:25:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/mround\/","url":"https:\/\/exceladvisor.org\/it\/mround\/","name":"Come utilizzare la funzione MROUND in Excel? (esempio)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/mround\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/mround\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png","datePublished":"2023-10-15T11:45:18+00:00","dateModified":"2023-12-10T06:25:13+00:00","description":"Un tutorial semplice e veloce per imparare a utilizzare la funzione MROUND in Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/mround\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/mround\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/mround\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/mround\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come utilizzare la funzione mround in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=2114"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2114\/revisions"}],"predecessor-version":[{"id":2649,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2114\/revisions\/2649"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=2114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}