{"id":1770,"date":"2023-11-06T00:29:38","date_gmt":"2023-11-06T00:29:38","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/"},"modified":"2023-12-06T05:50:47","modified_gmt":"2023-12-06T05:50:47","slug":"procentueel-verschil","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/","title":{"rendered":"Hoe procentuele variantie in excel berekenen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-530001418\"><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>Om een procentuele kloof (verschil) tussen twee waarden in Excel te berekenen, moet u een eenvoudige formule gebruiken. In deze formule kun je de oude waarden aftrekken van de nieuwe waarden en dat verschil vervolgens delen door de oude waarde. Op deze manier krijgt u de procentuele verandering ten opzichte van de oude waarde.<\/p><p> In het volgende voorbeeld heb je een lijst met oude waarden met nieuwe waarden. Nu moet u hier de procentuele variantie berekenen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67613\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"lijst met oude en nieuwe waarden\" width=\"317\" height=\"312\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Excel-formule om de procentuele variantie te berekenen<\/h2><ol type=\"1\"><li> Voer eerst een haakje beginpunt in en verwijs vervolgens naar de cel waar u een nieuwe waarde heeft.<\/li><li> Voer daarna een min-operator in en verwijs vervolgens naar de oude waarde.<\/li><li> Voer vervolgens een haakje sluiten in en voer de operator in en deel deze.<\/li><li> Raadpleeg nu de oude waarde en druk op Enter om het resultaat te krijgen.<\/li><li> Uiteindelijk moet u het formaat wijzigen van de cel waarin u de resultaatwaarde hebt. Gebruik dus de sneltoets \u201cCtrl + Shift +%\u201d. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67614\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-pour-obtenir-la-variance-en-pourcentage.png\" sizes=\"auto, \" srcset=\"\" alt=\"formule-om-percentage-variantie te krijgen\" width=\"444\" height=\"395\"><\/figure><\/div><h2 class=\"wp-block-heading\"> De formule begrijpen<\/h2><p> Laten we, om deze formule te begrijpen, deze in verschillende delen opsplitsen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67615\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-de-variance-a-3-pourcentages.png\" sizes=\"auto, \" srcset=\"\" alt=\"percentage-variantie-formule\" width=\"610\" height=\"121\"><\/figure><\/div><p> En zo ziet het eruit als je een echte waarde in de formule gebruikt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67616\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-valeur-reelle-dans-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"echte waarde in formule\" width=\"568\" height=\"143\"><\/figure><\/div><p> In het eerste deel, wanneer u de nieuwe waarde van de oude waarde verwijdert, krijgt u het verschil tussen de twee. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67617\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-supprimer-la-nouvelle-valeur-de-lancienne.png\" sizes=\"auto, \" srcset=\"\" alt=\"verwijder-nieuwe-waarde-van-oud\" width=\"307\" height=\"109\"><\/figure><\/div><p> In het tweede deel deel je dit verschil met de oude waarde, die een procentuele waarde retourneert die de variantie tussen de twee waarden is. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67618\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-diviser-la-difference-avec-lancienne-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"verdeel-verschil-met-oude-waarde\" width=\"264\" height=\"204\"><\/figure><\/div><p> Laten we nu terugkeren naar ons echte voorbeeld. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67619\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-exemple-avec-un-pourcentage-decart.png\" sizes=\"auto, \" srcset=\"\" alt=\"voorbeeld-met-percentage-variantie\" width=\"504\" height=\"357\"><\/figure><\/div><p> Wanneer u de formule naar de rest van de waarden sleept, ziet u dat deze ook de procentuele variantie voor alle waarden berekent. En we hebben ook een paar waarden met negatieve percentages waarbij we een nieuwe waarde hebben die kleiner is dan de oude waarde.<\/p><p class=\"qt-tip\"> <strong>Opmerking:<\/strong> Zorg ervoor dat u de celopmaak als percentage voor de resultaatcel gebruikt. Gebruik de sneltoets Ctrl+Shift+%. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Haal het Excel-bestand op<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/pourcentage-decart-2.xlsx\" rel=\"nofollow\">Downloaden<\/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\/nl\/formules\/\">Lijst met Excel-formules<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Gerelateerde formules <\/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> Bereken de derdemachtswortel in Excel<\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/vierkantswortel\/\">Bereken vierkantswortel in Excel + symbool invoegen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/is-niet-gelijk\/\">Is niet gelijk aan operator in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/vierkant-getal\/\">Vier een getal in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/optellen-aftrekken-van-een-percentage-van-een-getal\/\">Optellen en aftrekken van het percentage van een getal<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/cumulatief-bedrag-2\/\">Bereken de cumulatieve som van waarden<\/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-1770","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 Hoe procentuele variantie berekenen in Excel?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een formule gebruikt om de procentuele variantie (verschil) in Excel te berekenen.\" \/>\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\/nl\/procentueel-verschil\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe procentuele variantie berekenen in Excel?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een formule gebruikt om de procentuele variantie (verschil) in Excel te berekenen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/\",\"name\":\"\u25b7 Hoe procentuele variantie berekenen in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png\",\"datePublished\":\"2023-11-06T00:29:38+00:00\",\"dateModified\":\"2023-12-06T05:50:47+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een formule gebruikt om de procentuele variantie (verschil) in Excel te berekenen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe procentuele variantie in excel berekenen?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe procentuele variantie berekenen in Excel?","description":"In deze zelfstudie leert u hoe u een formule gebruikt om de procentuele variantie (verschil) in Excel te berekenen.","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\/nl\/procentueel-verschil\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe procentuele variantie berekenen in Excel?","og_description":"In deze zelfstudie leert u hoe u een formule gebruikt om de procentuele variantie (verschil) in Excel te berekenen.","og_url":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:47+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/","url":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/","name":"\u25b7 Hoe procentuele variantie berekenen in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png","datePublished":"2023-11-06T00:29:38+00:00","dateModified":"2023-12-06T05:50:47+00:00","description":"In deze zelfstudie leert u hoe u een formule gebruikt om de procentuele variantie (verschil) in Excel te berekenen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-des-anciennes-et-nouvelles-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/procentueel-verschil\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe procentuele variantie in excel berekenen?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1770"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1770\/revisions"}],"predecessor-version":[{"id":2788,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1770\/revisions\/2788"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}