{"id":2167,"date":"2023-09-26T11:31:25","date_gmt":"2023-09-26T11:31:25","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/"},"modified":"2023-12-06T05:53:21","modified_gmt":"2023-12-06T05:53:21","slug":"buikspieren-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/","title":{"rendered":"Wat is de abs-functie in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3947569021\"><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>De ABS-functie is het deel van de wiskundige functies van Excel dat kan worden gebruikt om elk getal naar een absoluut getal te converteren. In eenvoudige bewoordingen: converteer een negatief getal naar positief en zonder het positieve getal (retourneert een getal zonder teken) in de resultaatcel te be\u00efnvloeden. U kunt rechtstreeks naar de cel of de invoerwaarde in de functie verwijzen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72649\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png\" sizes=\"auto, \" srcset=\"\" alt=\"buikspieren functie\" width=\"455\" height=\"166\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Syntaxis<\/h2><p> ABS(aantal)<\/p><h2 class=\"wp-block-heading\"> Argumenten<\/h2><p> getal: een getal of waarde die u wilt converteren naar een absoluut getal.<\/p><h2 class=\"wp-block-heading\"> Voorbeeld<\/h2><p> In het onderstaande voorbeeld heb je enkele getallen in kolom A, en nu moet je de ABS-functie gebruiken om deze getallen naar absolute getallen te converteren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72650\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Donnees-a-2-chiffres.png\" sizes=\"auto, \" srcset=\"\" alt=\"cijfers-gegevens\" width=\"271\" height=\"315\"><\/figure><\/div><p> Het enige wat u hoeft te doen is de functie in de eerste cel toe te voegen, naar de cellen met de eerste waarde te verwijzen en deze vervolgens naar de laatste cel met de waarde te slepen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72651\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ajouter-la-fonction-abs-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-abs-functie-in-cel\" width=\"399\" height=\"330\"><\/figure><\/div><p> En in het volgende voorbeeld gebruikten we ABS om absolute waarden te krijgen met betrekking tot de verandering in de rente. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72652\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-abs-pour-obtenir-la-valeur-absolue.png\" sizes=\"auto, \" srcset=\"\" alt=\"abs-om-de-absolute-waarde te verkrijgen\" width=\"836\" height=\"135\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Opmerkingen<\/h2><ol><li> U kunt het nummer rechtstreeks in de functie invoegen.<\/li><li> Als u een getal opgeeft dat geen geheel getal is, wordt #WAARDE! geretourneerd.<\/li><li> U kunt ABS ook als arrayfunctie gebruiken.<\/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-2167","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>Wat is de ABS-functie in Excel? (Gids 2023)<\/title>\n<meta name=\"description\" content=\"De ABS-functie is het deel van de wiskundige functies van Excel dat kan worden gebruikt om elk getal naar a te converteren\" \/>\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\/buikspieren-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wat is de ABS-functie in Excel? (Gids 2023)\" \/>\n<meta property=\"og:description\" content=\"De ABS-functie is het deel van de wiskundige functies van Excel dat kan worden gebruikt om elk getal naar a te converteren\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:53:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.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=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/\",\"name\":\"Wat is de ABS-functie in Excel? (Gids 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png\",\"datePublished\":\"2023-09-26T11:31:25+00:00\",\"dateModified\":\"2023-12-06T05:53:21+00:00\",\"description\":\"De ABS-functie is het deel van de wiskundige functies van Excel dat kan worden gebruikt om elk getal naar a te converteren\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wat is de abs-functie in excel?\"}]},{\"@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":"Wat is de ABS-functie in Excel? (Gids 2023)","description":"De ABS-functie is het deel van de wiskundige functies van Excel dat kan worden gebruikt om elk getal naar a te converteren","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\/buikspieren-2\/","og_locale":"nl_NL","og_type":"article","og_title":"Wat is de ABS-functie in Excel? (Gids 2023)","og_description":"De ABS-functie is het deel van de wiskundige functies van Excel dat kan worden gebruikt om elk getal naar a te converteren","og_url":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:53:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/","url":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/","name":"Wat is de ABS-functie in Excel? (Gids 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png","datePublished":"2023-09-26T11:31:25+00:00","dateModified":"2023-12-06T05:53:21+00:00","description":"De ABS-functie is het deel van de wiskundige functies van Excel dat kan worden gebruikt om elk getal naar a te converteren","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/buikspieren-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-abs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/buikspieren-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Wat is de abs-functie in excel?"}]},{"@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\/2167","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=2167"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2167\/revisions"}],"predecessor-version":[{"id":2959,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2167\/revisions\/2959"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}