{"id":6752,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/arrondi-sup\/"},"modified":"2021-02-26T08:13:05","modified_gmt":"2021-02-26T08:13:05","slug":"roundup","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/roundup\/","title":{"rendered":"ARRONDI.SUP"},"content":{"rendered":"

Introduction \u00e0 ARRONDI.SUP<\/h2>\n

La fonction ARRONDI.SUP, disponible dans Microsoft Excel et Google Sheets, permet d’arrondir un nombre vers le haut, \u00e0 l’\u00e9cart de z\u00e9ro, jusqu’\u00e0 un nombre sp\u00e9cifi\u00e9 de d\u00e9cimales. Cette fonction est particuli\u00e8rement utile dans les contextes financiers o\u00f9 il est essentiel de s’assurer que les valeurs arrondies ne minimisent pas les montants originaux.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction ARRONDI.SUP :<\/p>\n

=ARRONDI.SUP(nombre, num_digits)<\/code><\/pre>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir.<\/li>\n
  • num_digits<\/strong> : Le nombre de d\u00e9cimales \u00e0 consid\u00e9rer pour l’arrondi. Si num_digits est positif, le nombre est arrondi \u00e0 ce nombre de d\u00e9cimales. Si num_digits est 0, le nombre est arrondi \u00e0 l’entier le plus proche. Si num_digits est n\u00e9gatif, l’arrondi s’effectue \u00e0 gauche du s\u00e9parateur d\u00e9cimal.<\/li>\n<\/ul>\n
    Par exemple, en utilisant =ARRONDI.SUP(2.123, 2)<\/code>, la fonction renverra 2.13.<\/p>\n
    Exemple d’utilisation<\/h2>\n
    Exemple 1 : Calcul de facturation<\/h3>\n
    Consid\u00e9rons une entreprise qui facture ses services \u00e0 la minute et souhaite arrondir chaque transaction au dixi\u00e8me de centime sup\u00e9rieur. Pour un co\u00fbt par minute de 0.067 euros, voici la formule pour calculer le co\u00fbt de 30 minutes :<\/p>\n
    =ARRONDI.SUP(30 * 0.067, 2)<\/code><\/pre>\n
    Dans cet exemple, le montant initial de 30 * 0.067 = 2.01<\/code> est arrondi \u00e0 2.01 euros en utilisant ARRONDI.SUP.<\/p>\n
    Exemple 2 : Calcul de mat\u00e9riaux<\/h3>\n
    Imaginons un entrepreneur qui doit commander des carreaux pour un projet n\u00e9cessitant pr\u00e9cis\u00e9ment 253.67 carreaux. Les carreaux ne pouvant \u00eatre achet\u00e9s qu’en quantit\u00e9s enti\u00e8res, ARRONDI.SUP peut d\u00e9terminer le nombre n\u00e9cessaire :<\/p>\n
    =ARRONDI.SUP(253.67, 0)<\/code><\/pre>\n
    Cela arrondira le nombre de carreaux \u00e0 254, garantissant assez de mat\u00e9riel pour couvrir la surface envisag\u00e9e.<\/p>\n
    Usages avanc\u00e9s et consid\u00e9rations<\/h2>\n
    L’utilisation de ARRONDI.SUP assure un arrondi syst\u00e9matique vers le haut, quel que soit le signe du nombre. Ainsi :<\/p>\n
    =ARRONDI.SUP(-3.14159, 2)<\/code><\/pre>\n
    Ce calcul retournera -3.14, car le chiffre est arrondi \u00e0 l’entier sup\u00e9rieur le plus proche.<\/p>\n
    Il est \u00e9galement essentiel de noter que les arrondis r\u00e9p\u00e9t\u00e9s dans des contextes financiers ou scientifiques peuvent introduire des erreurs significatives sur le long terme. Il est donc recommand\u00e9 d’utiliser cette fonction avec prudence.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Arrondit un nombre \u00e0 l\u2019entier sup\u00e9rieur, en s\u2019\u00e9loignAnt de z\u00e9ro<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6752","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ROUNDUP (ARRONDI.SUP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/roundup\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ROUNDUP (ARRONDI.SUP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/roundup\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:13:05+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/roundup\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/roundup\/\",\"name\":\"Fonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:13:05+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ROUNDUP (ARRONDI.SUP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/roundup\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/roundup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/roundup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ARRONDI.SUP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ROUNDUP (ARRONDI.SUP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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:\/\/functiontranslator.com\/fr\/roundup\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ROUNDUP (ARRONDI.SUP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/roundup\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:13:05+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/roundup\/","url":"https:\/\/functiontranslator.com\/fr\/roundup\/","name":"Fonction ROUNDUP (ARRONDI.SUP) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:13:05+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ROUNDUP (ARRONDI.SUP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/roundup\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/roundup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/roundup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"ARRONDI.SUP"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6752"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6752\/revisions"}],"predecessor-version":[{"id":29763,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6752\/revisions\/29763"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}