{"id":47870,"date":"2015-06-22T09:35:57","date_gmt":"2015-06-22T08:35:57","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=47870"},"modified":"2017-11-17T14:31:48","modified_gmt":"2017-11-17T13:31:48","slug":"0-nul-of-niets-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/0-nul-of-niets-in-excel\/","title":{"rendered":"0, nul of niets in Excel"},"content":{"rendered":"<p>V. Wat is het verschil tussen 0, nul of niets (lege cel) in Excel?<\/p>\n<p>A. Terwijl een lege cel gewoon leeg is, is 0 een getal (en dan is de cel niet leeg) en &#8220;nul&#8221; is een string of letterreeks waar je (in principe) niet mee kan rekenen.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-47873\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-1-276x300.png\" alt=\"nul-1\" width=\"276\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-1-276x300.png 276w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-1.png 279w\" sizes=\"auto, (max-width: 276px) 100vw, 276px\" \/><\/a><\/p>\n<p>Het verschil valt vooral op bij het maken van grafieken. 0, nul of niets (lege cel) geven een blanco in een kolomgrafiek.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-47872\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-2-300x178.png\" alt=\"nul-2\" width=\"300\" height=\"178\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-2-300x178.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-2.png 714w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Maar bij een lijngrafiek wordt er alleen 0 weergegeven (springt de grafiek naar de X-as) bij 0 en nul.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-47871\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-3-300x178.png\" alt=\"nul-3\" width=\"300\" height=\"178\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-3-300x178.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-3.png 739w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>En in <a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2015\/06\/nul-0-empty.xlsx\">dit bestand<\/a> kan je alles eens bekijken.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Wat is het verschil tussen 0, nul of niets (lege cel) in Excel? A. Terwijl een lege cel gewoon leeg is, is 0 een getal (en dan is de cel niet leeg) en &#8220;nul&#8221; is een string of letterreeks waar je (in principe) niet mee kan rekenen. Het verschil<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":21,"footnotes":""},"categories":[464,54,375,10],"tags":[],"class_list":["post-47870","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 10:12:10","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/47870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=47870"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/47870\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=47870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=47870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=47870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}