{"id":6548,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/plancher-math\/"},"modified":"2021-02-26T08:06:28","modified_gmt":"2021-02-26T08:06:28","slug":"floor-math","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/floor-math\/","title":{"rendered":"PLANCHER.MATH"},"content":{"rendered":"

Description et Syntaxe<\/h2>\n

La fonction PLANCHER.MATH<\/strong> dans Excel et Google Sheets permet d’arrondir un nombre vers le bas jusqu’au multiple le plus proche d’une valeur sp\u00e9cifi\u00e9e. Cette fonction est particuli\u00e8rement utile dans divers contextes tels que la comptabilit\u00e9, l’analyse de donn\u00e9es et les math\u00e9matiques financi\u00e8res, o\u00f9 des arrondis sp\u00e9cifiques sont requis.<\/p>\n

La syntaxe de la fonction est la suivante : <\/p>\n

PLANCHER.MATH(nombre; [signif]; [mode])<\/code><\/pre>\n<\/p>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir.<\/li>\n
  • signif<\/strong> (facultatif) : Le multiple souhait\u00e9 pour l’arrondi. Par d\u00e9faut, cette valeur est 1.<\/li>\n
  • mode<\/strong> (facultatif) : Ce param\u00e8tre d\u00e9termine la mani\u00e8re d’arrondir les nombres n\u00e9gatifs. Si ce param\u00e8tre est omis ou \u00e9gal \u00e0 0, les nombres n\u00e9gatifs sont arrondis vers z\u00e9ro. S’il prend une valeur diff\u00e9rente, les nombres n\u00e9gatifs sont arrondis \u00e0 l’infini n\u00e9gatif.<\/li>\n<\/ul>\n
    Exemples<\/h2>\n
    Voici quelques exemples pour illustrer l’utilisation de la fonction :<\/p>\n
    =PLANCHER.MATH(6.7) donne 6 =PLANCHER.MATH(-6.7) donne -7 =PLANCHER.MATH(6.7; 2) donne 6 =PLANCHER.MATH(-6.7; 2) donne -8 =PLANCHER.MATH(-6.7; 2; 0) donne -6<\/code><\/pre>\n
    Sc\u00e9narios Pratiques<\/h2>\n
    Exemple 1 : Pr\u00e9paration des paquets<\/h3>\n
    Supposons que vous deviez pr\u00e9parer des paquets de biscuits, chaque paquet pouvant contenir exactement 24 biscuits. Pour une commande de 250 biscuits, combien de paquets complets pouvez-vous pr\u00e9parer ?<\/p>\n
    La formule \u00e0 utiliser serait :<\/p>\n
    =PLANCHER.MATH(250\/24; 1)<\/code><\/pre>\n
    Ce calcul donne un r\u00e9sultat de 10, ce qui signifie que 10 paquets complets peuvent \u00eatre pr\u00e9par\u00e9s.<\/p>\n
    Exemple 2 : Temps de travail<\/h3>\n
    Un consultant facture ses services par tranche de 15 minutes. Si un travail a dur\u00e9 67 minutes, quelle sera la dur\u00e9e factur\u00e9e ?<\/p>\n
    Utilisez la formule :<\/p>\n
    =PLANCHER.MATH(67\/15; 1) * 15<\/code><\/pre>\n
    Le r\u00e9sultat est 60, donc le consultant facturera 60 minutes de travail, ce qui correspond au multiple de 15 le plus proche inf\u00e9rieur \u00e0 67.<\/p>\n
    Ces exemples illustrent bien la flexibilit\u00e9 et l\u2019utilit\u00e9 de la fonction PLANCHER.MATH<\/strong> dans des situations r\u00e9elles, permettant des calculs pr\u00e9cis et conformes aux r\u00e8gles d\u2019arrondissement sp\u00e9cifiques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Arrondit un nombre au nombre entier inf\u00e9rieur le plus proche ou au multiple le plus proche de l\u2019argument pr\u00e9cision en tendant vers 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-6548","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction FLOOR.MATH (PLANCHER.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction FLOOR.MATH (PLANCHER.MATH) 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\/floor-math\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction FLOOR.MATH (PLANCHER.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction FLOOR.MATH (PLANCHER.MATH) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/floor-math\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:06:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction FLOOR.MATH (PLANCHER.MATH) 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\/floor-math\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/floor-math\/\",\"name\":\"Fonction FLOOR.MATH (PLANCHER.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:06:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction FLOOR.MATH (PLANCHER.MATH) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/floor-math\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/floor-math\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/floor-math\/#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\":\"PLANCHER.MATH\"}]},{\"@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 FLOOR.MATH (PLANCHER.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction FLOOR.MATH (PLANCHER.MATH) 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\/floor-math\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction FLOOR.MATH (PLANCHER.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction FLOOR.MATH (PLANCHER.MATH) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/floor-math\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction FLOOR.MATH (PLANCHER.MATH) 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\/floor-math\/","url":"https:\/\/functiontranslator.com\/fr\/floor-math\/","name":"Fonction FLOOR.MATH (PLANCHER.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:06:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction FLOOR.MATH (PLANCHER.MATH) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/floor-math\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/floor-math\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/floor-math\/#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":"PLANCHER.MATH"}]},{"@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\/6548","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=6548"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6548\/revisions"}],"predecessor-version":[{"id":29559,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6548\/revisions\/29559"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}