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

Introduction \u00e0 la fonction ARRONDI.INF<\/h2>\n

La fonction ARRONDI.INF de Microsoft Excel et Google Sheets permet d’arrondir un nombre sp\u00e9cifi\u00e9 vers le bas jusqu’au multiple le plus proche d’un certain nombre de d\u00e9cimales. Elle est tr\u00e8s utile dans le traitement des donn\u00e9es financi\u00e8res et pour les analyses n\u00e9cessitant une pr\u00e9cision des calculs maitris\u00e9e.<\/p>\n

Syntaxe de la fonction<\/h2>\n

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

=ARRONDI.INF(nombre, num_digits)<\/code><\/pre>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir.<\/li>\n
  • num_digits<\/strong> : Le nombre de d\u00e9cimales souhait\u00e9 pour l’arrondissement vers le bas.<\/li>\n<\/ul>\n
    Exemple d’utilisation:<\/p>\n
    =ARRONDI.INF(3.14159, 2) \/\/ R\u00e9sultat : 3.14<\/code><\/pre>\n
    Applications pratiques<\/h2>\n
    Ci-dessous, quelques exemples d’application de cette fonction dans divers contextes.<\/p>\n
    Cas pratique 1 : Calcul de remises<\/h2>\n
    Imaginons que vous soyez employ\u00e9 dans un magasin o\u00f9 il faut appliquer une remise de 15% sur des produits aux prix non arrondis. Vous souhaitez pr\u00e9senter des prix finaux arrondis pour simplifier le paiement pour les clients.<\/p>\n\n\n\n\n
    Produit<\/th>\nPrix Original<\/th>\nPrix avec Remise<\/th>\nPrix Final Arrondi<\/th>\n<\/tr>\n
    Chemise<\/td>\n\u20ac19.99<\/td>\n\u20ac16.9915<\/td>\n=ARRONDI.INF(16.9915, 1) \u2192 \u20ac16.9<\/td>\n<\/tr>\n
    Pantalon<\/td>\n\u20ac39.99<\/td>\n\u20ac33.9915<\/td>\n=ARRONDI.INF(33.9915, 1) \u2192 \u20ac33.9<\/td>\n<\/tr>\n<\/table>\n
    Cette m\u00e9thode assure que les prix sont syst\u00e9matiquement arrondis vers le bas \u00e0 la d\u00e9cimale la plus proche, facilitant ainsi le calcul du montant total pour les clients.<\/p>\n
    Cas pratique 2 : Rapports financiers<\/h2>\n
    Consid\u00e9rons que vous \u00eates comptable et devez pr\u00e9parer un rapport financier n\u00e9cessitant que tous les montants soient arrondis \u00e0 l’euro le plus proche pour simplifier les proc\u00e9dures administratives.<\/p>\n
    Budget initial : \u20ac123456.789 D\u00e9penses : \u20ac98765.432 Budget final estim\u00e9 = 123456.789 - 98765.432 Budget final arrondi : =ARRONDI.INF(Budget final estim\u00e9, 0)<\/code><\/pre>\n
    En utilisant ARRONDI.INF avec un argument num_digits<\/code> de 0, toute valeur comprenant des centimes dans le calcul pr\u00e9liminaire sera arrondie vers le bas \u00e0 l’euro le plus proche, rendant le rapport plus lisible et facile \u00e0 comprendre.<\/p>\n
     The revised HTML content effectively retains technical details and applications while delivering more polished and professional language usage.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Arrondit un nombre en tendAnt vers 0 (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-6751","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction ROUNDDOWN (ARRONDI.INF) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ROUNDDOWN (ARRONDI.INF) 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\/rounddown\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ROUNDDOWN (ARRONDI.INF) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ROUNDDOWN (ARRONDI.INF) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/rounddown\/\" \/>\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:03+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ROUNDDOWN (ARRONDI.INF) 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\/rounddown\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/rounddown\/\",\"name\":\"Fonction ROUNDDOWN (ARRONDI.INF) 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:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ROUNDDOWN (ARRONDI.INF) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/rounddown\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/rounddown\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rounddown\/#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.INF\"}]},{\"@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 ROUNDDOWN (ARRONDI.INF) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ROUNDDOWN (ARRONDI.INF) 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\/rounddown\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ROUNDDOWN (ARRONDI.INF) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ROUNDDOWN (ARRONDI.INF) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/rounddown\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:13:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ROUNDDOWN (ARRONDI.INF) 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\/rounddown\/","url":"https:\/\/functiontranslator.com\/fr\/rounddown\/","name":"Fonction ROUNDDOWN (ARRONDI.INF) 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:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ROUNDDOWN (ARRONDI.INF) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/rounddown\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/rounddown\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/rounddown\/#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.INF"}]},{"@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\/6751","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=6751"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6751\/revisions"}],"predecessor-version":[{"id":29762,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6751\/revisions\/29762"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}