{"id":55565,"date":"2019-12-28T18:35:44","date_gmt":"2019-12-28T17:35:44","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=55565"},"modified":"2021-06-29T17:11:15","modified_gmt":"2021-06-29T16:11:15","slug":"een-bedrag-afronden-op-5-cent","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/een-bedrag-afronden-op-5-cent\/","title":{"rendered":"Een bedrag afronden op 5 cent"},"content":{"rendered":"<p>Ter opvolging van<a href=\"https:\/\/hlrnet.com\/technoblog\/afronden-op-10-cent\/\"> een eerdere post<\/a><\/p>\n<p>V. Hoe kan ik afronden op 5 cent?<\/p>\n<p>A. Er zijn drie Excel functies die je kan gebruiken &#8211; maar ze geven niet hetzelfde resultaat.<\/p>\n<ul>\n<li>AFRONDEN (ROUND)<\/li>\n<li>AFRONDEN.N.VEELVOUD (MROUND)<\/li>\n<li>INTEGER (INT) &#8211; die mijn absolute voorkeur geniet.<\/li>\n<\/ul>\n<p>Bij wijze van voorbeeld:<\/p>\n<ul>\n<li>Een set van willekeurige getallen \/ bedragen op 1 cent tussen 5 en -5<br \/>\n=ASELECTTUSSEN(100;1000)\/100-<\/li>\n<li>Afronden op een veelvoud van .05<br \/>\n=AFRONDEN.N.VEELVOUD(A3;0,05)<\/li>\n<li>Delen door 20 na eerst afgerond te hebben<br \/>\n=AFRONDEN(A3*20;0)\/20<\/li>\n<li>Afronden met integer<br \/>\n=INTEGER(A3*20+0,5)\/20<\/li>\n<\/ul>\n<p>Die gegevens zien er bv zo uit:<\/p>\n<table style=\"border-collapse: collapse; width: 1011px; height: 885px;\" border=\"0\" width=\"320\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col style=\"width: 48pt;\" span=\"5\" width=\"64\" \/> <\/colgroup>\n<tbody>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt; width: 48pt;\" width=\"64\" height=\"19\">bedrag<\/td>\n<td style=\"width: 48pt;\" width=\"64\">afronding<\/td>\n<td style=\"width: 48pt;\" width=\"64\"><\/td>\n<td style=\"width: 48pt;\" width=\"64\"><\/td>\n<td style=\"width: 48pt;\" width=\"64\"><\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" height=\"19\"><\/td>\n<td>AFRONDEN.N.VEELVOUD<\/td>\n<td>AFRONDEN<\/td>\n<td>INTEGER<\/td>\n<td>INTEGER<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">-2,82<\/td>\n<td align=\"center\">#GETAL!<\/td>\n<td align=\"right\">-2,8<\/td>\n<td align=\"right\">-2,8<\/td>\n<td align=\"right\">-2,85<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">-0,26<\/td>\n<td align=\"center\">#GETAL!<\/td>\n<td align=\"right\">-0,25<\/td>\n<td align=\"right\">-0,25<\/td>\n<td align=\"right\">-0,3<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">3,19<\/td>\n<td align=\"right\">3,2<\/td>\n<td align=\"right\">3,2<\/td>\n<td align=\"right\">3,2<\/td>\n<td align=\"right\">3,2<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">4,94<\/td>\n<td align=\"right\">4,95<\/td>\n<td align=\"right\">4,95<\/td>\n<td align=\"right\">4,95<\/td>\n<td align=\"right\">4,95<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">0,04<\/td>\n<td align=\"right\">0,05<\/td>\n<td align=\"right\">0,05<\/td>\n<td align=\"right\">0,05<\/td>\n<td align=\"right\">0,05<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">1,42<\/td>\n<td align=\"right\">1,4<\/td>\n<td align=\"right\">1,4<\/td>\n<td align=\"right\">1,4<\/td>\n<td align=\"right\">1,4<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">-1,77<\/td>\n<td align=\"center\">#GETAL!<\/td>\n<td align=\"right\">-1,75<\/td>\n<td align=\"right\">-1,75<\/td>\n<td align=\"right\">-1,8<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">4,52<\/td>\n<td align=\"right\">4,5<\/td>\n<td align=\"right\">4,5<\/td>\n<td align=\"right\">4,5<\/td>\n<td align=\"right\">4,5<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">-3,28<\/td>\n<td align=\"center\">#GETAL!<\/td>\n<td align=\"right\">-3,3<\/td>\n<td align=\"right\">-3,3<\/td>\n<td align=\"right\">-3,3<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">1,52<\/td>\n<td align=\"right\">1,5<\/td>\n<td align=\"right\">1,5<\/td>\n<td align=\"right\">1,5<\/td>\n<td align=\"right\">1,5<\/td>\n<\/tr>\n<tr style=\"height: 14.4pt;\">\n<td style=\"height: 14.4pt;\" align=\"right\" height=\"19\">-2,74<\/td>\n<td align=\"center\">#GETAL!<\/td>\n<td align=\"right\">-2,75<\/td>\n<td align=\"right\">-2,75<\/td>\n<td align=\"right\">-2,75<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Wat opvalt:<\/p>\n<ul>\n<li>AFRONDEN.N.VEELVOUD kan niet omgaan met negatieve getallen. Eigenlijk is dat logisch: als 3.78 &#8216;natuurlijk&#8217; afrondt op 3.8, waarop moet -3.78 uitkomen? Wat is naar beneden \/ naar boven afronden, en wanneer??<\/li>\n<li>Afhankelijk van de beslissing die men wil nemen voor negatieve getallen, zijn de twee laatste berekeningen de beste.\n<ul>\n<li>=INTEGER(A3*20+0,5)\/20<\/li>\n<li>=ALS(A3&gt;=0;INTEGER(A3*20+0,5)\/20;INTEGER(A3*20)\/20)<br \/>\nwaarbij ik ben uitgegaan van afronding korter naar nul indien het decimaal gedeelte kleiner is dan .5, en verder van nul indien groter dan .5<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>In bijlage <a href=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/12\/afronden-op-5-cent.xlsx\">het Excel bestand met de willekeurige getallen en de verschillende formules voor het afronden op 5 cent<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ter opvolging van een eerdere post V. Hoe kan ik afronden op 5 cent? A. Er zijn drie Excel functies die je kan gebruiken &#8211; maar ze geven niet hetzelfde resultaat. AFRONDEN (ROUND) AFRONDEN.N.VEELVOUD (MROUND) INTEGER (INT) &#8211; die mijn absolute voorkeur geniet. Bij wijze van voorbeeld: Een set van<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":362,"footnotes":""},"categories":[539,54,79,10,572],"tags":[559],"class_list":["post-55565","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-excel","category-odisee","category-office","category-puntenboek","tag-afronden"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 04:27:33","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\/55565","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=55565"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/55565\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=55565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=55565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=55565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}