{"id":3097,"date":"2023-11-15T12:57:17","date_gmt":"2023-11-15T12:57:17","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/"},"modified":"2023-12-03T13:04:48","modified_gmt":"2023-12-03T13:04:48","slug":"auf-die-nachste-5-runden","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/","title":{"rendered":"Wie rundet man in excel auf die n\u00e4chsten 0,5, 5 und 50?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-3938287131\"><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>In diesem Formel-Tutorial lernen wir, wie man eine Zahl auf die n\u00e4chsten 5, 50 und 0,5 rundet. Sie k\u00f6nnen diese Formeln in Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 und Excel f\u00fcr Mac verwenden.<\/p><h2 class=\"wp-block-heading\"> Runden Sie auf die n\u00e4chsten 0,5, 5 und 50<\/h2><p> Um auf die n\u00e4chsten 5 zu runden, k\u00f6nnen Sie die Funktion MROUND verwenden, bei der Sie das Argument angeben k\u00f6nnen, um das Vielfache davon zu erhalten. Schauen Sie sich die folgende Formel an. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63656\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\" sizes=\"auto, \" srcset=\"\" alt=\"runde Funktion\" width=\"420\" height=\"195\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MROUND(A2,5)<\/code><\/pre><p> In der Formel oben haben Sie 5 als Vielfaches verwendet, um den Wert zu runden. Wenn Sie sich nun den ersten Wert in Zelle A2 ansehen, der 4 ist und das n\u00e4chste Vielfache von 5 5 ist. Und f\u00fcr den zweiten Wert haben Sie 15, was das n\u00e4chste Vielfache von 5 ist.<\/p><p> Ebenso k\u00f6nnen Sie mit der MROUND-Funktion 50 verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63657\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-mround-fonction-avec-argument.png\" sizes=\"auto, \" srcset=\"\" alt=\"mround-function-with-argument\" width=\"415\" height=\"217\"><\/figure><\/div><p> Und die gleiche Funktion gilt f\u00fcr .5. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63658\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-mrond-fonction-rond-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"mround-function-round-nearest\" width=\"425\" height=\"207\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Runden Sie auf die n\u00e4chste 5<\/h2><p> Um eine Zahl auf 5 zu runden, m\u00fcssen Sie die FLOOR-Funktion verwenden. Diese Funktion hat dieselben Argumente wie die MROUND-Funktion. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63659\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-arrondir-au-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"auf die n\u00e4chsten f\u00fcnf runden\" width=\"431\" height=\"202\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=FLOOR(D8,5)<\/code><\/pre><p> Und das Gleiche gilt f\u00fcr die 50. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63660\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-arrondir-a-la-cinquantaine-inferieure.png\" sizes=\"auto, \" srcset=\"\" alt=\"auf die n\u00e4chsten f\u00fcnfzig runden\" width=\"436\" height=\"201\"><\/figure><\/div><p> Und auch f\u00fcr .5. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63661\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-arrondir-au-point-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"Runden Sie auf die n\u00e4chste Zahl F\u00fcnf\" width=\"442\" height=\"203\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Auf die n\u00e4chsten 5 gerundet<\/h2><p> Um eine Zahl auf die n\u00e4chste 5 zu runden, m\u00fcssen Sie die Funktion CEILING verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63662\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-arrondir-au-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"auf die n\u00e4chsten f\u00fcnf runden\" width=\"453\" height=\"200\"><\/figure><\/div><p> Str. 50. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63663\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-arrondir-a-la-cinquantaine-la-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"auf die n\u00e4chsten f\u00fcnfzig runden\" width=\"458\" height=\"210\"><\/figure><\/div><p> Und am Ende f\u00fcr .5. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63664\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-arrondir-au-point-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"auf die n\u00e4chste Komma f\u00fcnf gerundet\" width=\"455\" height=\"206\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Holen Sie sich die Excel-Datei<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/arrondir-au-cinq-superieur-le-plus-proche.xlsx\" rel=\"nofollow\">Herunterladen<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/formeln\/\">Liste der Excel-Formeln<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Verwandte Formeln <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/auf-den-nachsten-tausender-runden\/\">Runden Sie eine Zahl in Excel auf die n\u00e4chste 1000<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/runder-prozentsatz-2\/\">Runde Werte in Prozent<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","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-3097","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>\u25b7 Wie rundet man in Excel auf die n\u00e4chsten 0,5, 5 und 50?<\/title>\n<meta name=\"description\" content=\"Um auf die n\u00e4chsten 5 zu runden, k\u00f6nnen Sie die Funktion MROUND verwenden, in der Sie das Argument f\u00fcr angeben k\u00f6nnen\" \/>\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\/de\/auf-die-nachste-5-runden\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Wie rundet man in Excel auf die n\u00e4chsten 0,5, 5 und 50?\" \/>\n<meta property=\"og:description\" content=\"Um auf die n\u00e4chsten 5 zu runden, k\u00f6nnen Sie die Funktion MROUND verwenden, in der Sie das Argument f\u00fcr angeben k\u00f6nnen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:04:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/\",\"name\":\"\u25b7 Wie rundet man in Excel auf die n\u00e4chsten 0,5, 5 und 50?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\",\"datePublished\":\"2023-11-15T12:57:17+00:00\",\"dateModified\":\"2023-12-03T13:04:48+00:00\",\"description\":\"Um auf die n\u00e4chsten 5 zu runden, k\u00f6nnen Sie die Funktion MROUND verwenden, in der Sie das Argument f\u00fcr angeben k\u00f6nnen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie rundet man in excel auf die n\u00e4chsten 0,5, 5 und 50?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Wie rundet man in Excel auf die n\u00e4chsten 0,5, 5 und 50?","description":"Um auf die n\u00e4chsten 5 zu runden, k\u00f6nnen Sie die Funktion MROUND verwenden, in der Sie das Argument f\u00fcr angeben k\u00f6nnen","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\/de\/auf-die-nachste-5-runden\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie rundet man in Excel auf die n\u00e4chsten 0,5, 5 und 50?","og_description":"Um auf die n\u00e4chsten 5 zu runden, k\u00f6nnen Sie die Funktion MROUND verwenden, in der Sie das Argument f\u00fcr angeben k\u00f6nnen","og_url":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:04:48+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/","url":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/","name":"\u25b7 Wie rundet man in Excel auf die n\u00e4chsten 0,5, 5 und 50?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png","datePublished":"2023-11-15T12:57:17+00:00","dateModified":"2023-12-03T13:04:48+00:00","description":"Um auf die n\u00e4chsten 5 zu runden, k\u00f6nnen Sie die Funktion MROUND verwenden, in der Sie das Argument f\u00fcr angeben k\u00f6nnen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/auf-die-nachste-5-runden\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie rundet man in excel auf die n\u00e4chsten 0,5, 5 und 50?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3097"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3097\/revisions"}],"predecessor-version":[{"id":4178,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3097\/revisions\/4178"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}