{"id":45281,"date":"2014-03-07T17:42:18","date_gmt":"2014-03-07T16:42:18","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=45281"},"modified":"2014-03-08T13:18:39","modified_gmt":"2014-03-08T12:18:39","slug":"afronden-op-10-cent","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/afronden-op-10-cent\/","title":{"rendered":"Afronden op 10 cent"},"content":{"rendered":"<p>V. Kan ik een bedrag in Excel afronden op 10 cent? Binnenkort verdwijnen de koperen muntjes.<\/p>\n<p>A. Ja, je kan dat doen met INTEGER. Gebruik geen weergavetruucjes &#8211; het bedrag kan er dan wel afgerond uit zien, maar je kan onverwachte dingen krijgen bij berekeningen &#8211; en jij bent de enige verantwoordelijke.<\/p>\n<p>Afronding 1<br \/>\n=INT(A2*10)\/10<\/p>\n<p>Afronding 2 (met 5\/4 afronding)<br \/>\n=INT(A2*10+0,5)\/10<\/p>\n<p>En dat geeft:<\/p>\n<table width=\"211\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col \/>\n<col \/>\n<col \/><\/colgroup>\n<tbody>\n<tr>\n<td>prijs<\/td>\n<td>afronding1<\/td>\n<td>afronding2<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,01<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,02<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,03<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,04<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,05<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,06<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,07<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,08<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,09<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,00<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,1<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,11<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,12<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,13<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,14<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,15<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,16<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,17<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,18<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,19<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,10<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">1,2<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,20<\/td>\n<td>\u00c2\u00a0\u00e2\u201a\u00ac 1,20<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik een bedrag in Excel afronden op 10 cent? Binnenkort verdwijnen de koperen muntjes. A. Ja, je kan dat doen met INTEGER. Gebruik geen weergavetruucjes &#8211; het bedrag kan er dan wel afgerond uit zien, maar je kan onverwachte dingen krijgen bij berekeningen &#8211; en jij bent de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":11,"footnotes":""},"categories":[104,54,79,10],"tags":[],"class_list":["post-45281","post","type-post","status-publish","format-standard","hentry","category-business","category-excel","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 09:56:07","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\/45281","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=45281"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/45281\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=45281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=45281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=45281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}