{"id":59,"date":"2021-10-07T00:26:00","date_gmt":"2021-10-06T22:26:00","guid":{"rendered":"http:\/\/excel4ever.fr\/?p=59"},"modified":"2021-10-07T00:27:16","modified_gmt":"2021-10-06T22:27:16","slug":"la-formule-arrondi","status":"publish","type":"post","link":"https:\/\/excel4ever.fr\/index.php\/2021\/10\/07\/la-formule-arrondi\/","title":{"rendered":"La formule ARRONDI"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>ARRONDI(nombre; no_chiffres)<\/p><\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<p>Cette fonction suit les conventions math\u00e9matiques :<\/p>\n\n\n\n<p>Si le chiffre qui pr\u00e9c\u00e8de le chiffre tronqu\u00e9 est strictement inf\u00e9rieur \u00e0 5, on arrondit au m\u00eame chiffre.<\/p>\n\n\n\n<p>Si le chiffre qui pr\u00e9c\u00e8de le chiffre tronqu\u00e9 est \u00e9gal ou sup\u00e9rieur \u00e0 5, on arrondit au chiffre sup\u00e9rieur.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Le premier argument de la fonction est le nombre que l&rsquo;on veut tronquer, ou la r\u00e9f\u00e9rence de la cellule qui contient le nombre \u00e0 tronquer.<\/p>\n\n\n\n<p>Le second argument est le nombre de chiffres que l&rsquo;on veut conserver apr\u00e8s la virgule. Quelques exemples :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"310\" height=\"332\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-001.png\" alt=\"\" class=\"wp-image-286\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-001.png 310w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-001-280x300.png 280w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-001-233x250.png 233w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/><\/figure>\n\n\n\n<p>A noter qu&rsquo;il est possible d&rsquo;arrondir la partie enti\u00e8re \u00e0 gauche de la virgule en indiquant un chiffre n\u00e9gatif pour le second argument. Dans ce cas, la r\u00e8gle qui s&rsquo;applique est la suivante :<\/p>\n\n\n\n<p>La valeur -1 arrondit le chiffre au multiple de 10 le plus proche<\/p>\n\n\n\n<p>La valeur -2 arrondit le chiffre au multiple de 100 le plus proche<\/p>\n\n\n\n<p>La valeur -3 arrondit le chiffre au multiple de 1000 le plus proche<\/p>\n\n\n\n<p>Et ainsi de suite, ce qui nous donne ceci :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"298\" height=\"112\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-002.png\" alt=\"\" class=\"wp-image-287\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-002.png 298w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-002-250x94.png 250w\" sizes=\"auto, (max-width: 298px) 100vw, 298px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Cette fonction ARRONDI poss\u00e8de deux variantes qui modifient l\u00e9g\u00e8rement son comportement selon ce que l&rsquo;on souhaite faire.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>ARRONDI.INF(nombre; no_chiffres)<\/p><p>ARRONDI.SUP(nombre; no_chiffres)<\/p><\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<p>ARRONDI.INF permet de forcer l&rsquo;arrondi au chiffre inf\u00e9rieur. ARRONDI.SUP fait l&rsquo;inverse, il permet de forcer l&rsquo;arrondi au chiffre sup\u00e9rieur :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"319\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-003.png\" alt=\"\" class=\"wp-image-288\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-003.png 614w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-003-300x156.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/10\/0016-003-250x130.png 250w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ARRONDI(nombre; no_chiffres) Cette fonction suit les conventions math\u00e9matiques : Si le chiffre qui pr\u00e9c\u00e8de le chiffre tronqu\u00e9 est strictement inf\u00e9rieur \u00e0 5, on arrondit au m\u00eame chiffre. Si le chiffre qui pr\u00e9c\u00e8de le chiffre tronqu\u00e9 est \u00e9gal ou sup\u00e9rieur \u00e0 5, on arrondit au chiffre sup\u00e9rieur. Le premier argument de la fonction est le nombre [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-les-formules-et-fonctions"],"_links":{"self":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":4,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"predecessor-version":[{"id":291,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions\/291"}],"wp:attachment":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}