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

Description et syntaxe<\/h2>\n

La fonction PLANCHER.PRECIS<\/strong> arrondit un nombre \u00e0 l’entier inf\u00e9rieur ou \u00e9gal le plus proche, en accord avec un facteur de multiplication sp\u00e9cifique. Disponible dans Microsoft Excel et Google Sheets, cette fonction est essentielle pour standardiser des donn\u00e9es, d\u00e9terminer des prix ou calculer des quantit\u00e9s par lots.<\/p>\n

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

=PLANCHER.PRECIS(nombre, [facteur])<\/code><\/pre>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir vers le bas.<\/li>\n
  • facteur<\/strong> (optionnel) : Le multiple utilis\u00e9 pour l’arrondissement. Si cet argument n’est pas sp\u00e9cifi\u00e9, il est consid\u00e9r\u00e9 comme \u00e9tant 1.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Ci-dessous, quelques exemples qui d\u00e9montrent l’utilisation de la fonction PLANCHER.PRECIS<\/strong>.<\/p>\n
    =PLANCHER.PRECIS(6.7) \/\/ R\u00e9sultat : 6 =PLANCHER.PRECIS(6.7, 1) \/\/ R\u00e9sultat : 6 =PLANCHER.PRECIS(6.7, 2) \/\/ R\u00e9sultat : 6 =PLANCHER.PRECIS(-5.5, 2) \/\/ R\u00e9sultat : -6<\/code><\/pre>\n
    Sc\u00e9narios d’application pratique<\/h2>\n
    Sc\u00e9nario 1: Calcul des quantit\u00e9s d’achat en gros<\/h3>\n
    Supposons que vous \u00eates responsable des stocks et devez commander des bo\u00eetes de vis, vendues par lots de 50. Si un projet n\u00e9cessite 280 vis, la fonction PLANCHER.PRECIS<\/strong> vous aide \u00e0 d\u00e9terminer le nombre de paquets \u00e0 commander.<\/p>\n
    =PLANCHER.PRECIS(280, 50)<\/code><\/pre>\n
    Le r\u00e9sultat indique qu’il vous faut commander 5 paquets, soit 250 vis, puisque la fonction arrondit 280 au multiple inf\u00e9rieur le plus proche de 50.<\/p>\n
    Sc\u00e9nario 2: Arrondissement des heures de travail pour la facturation<\/h3>\n
    En tant que consultant facturant par tranches de quinze minutes, si vous travaillez 7 heures et 38 minutes, PLANCHER.PRECIS<\/strong> peut arrondir ce temps au quart d’heure le plus proche.<\/p>\n
    \/\/ Conversion des minutes en heures =PLANCHER.PRECIS(7 + 38\/60, 1\/4)<\/code><\/pre>\n
    Cela correspond \u00e0 7,5 heures, donc vous facturez 7 heures et 30 minutes.<\/p>\n
    Ces exemples illustrent l’utilit\u00e9 de la fonction PLANCHER.PRECIS<\/strong> dans des contextes professionnels pour la simplification des calculs et la gestion efficace des t\u00e2ches quotidiennes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Arrondit un nombre Au nombre entier le plus proche ou Au multiple le plus proche de l\u2019Argument pr\u00e9cision en s\u2019\u00e9loignAnt de z\u00e9ro Quel que soit son signe, ce nombre est Arrondi \u00e0 l\u2019entier sup\u00e9rieur<\/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-6549","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction FLOOR.PRECISE (PLANCHER.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction FLOOR.PRECISE (PLANCHER.PRECIS) 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-precise\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction FLOOR.PRECISE (PLANCHER.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction FLOOR.PRECISE (PLANCHER.PRECIS) 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-precise\/\" \/>\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:30+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.PRECISE (PLANCHER.PRECIS) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/floor-precise\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/floor-precise\/\",\"name\":\"Fonction FLOOR.PRECISE (PLANCHER.PRECIS) 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:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction FLOOR.PRECISE (PLANCHER.PRECIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/floor-precise\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/floor-precise\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/floor-precise\/#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.PRECIS\"}]},{\"@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.PRECISE (PLANCHER.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction FLOOR.PRECISE (PLANCHER.PRECIS) 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-precise\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction FLOOR.PRECISE (PLANCHER.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction FLOOR.PRECISE (PLANCHER.PRECIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/floor-precise\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction FLOOR.PRECISE (PLANCHER.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/floor-precise\/","url":"https:\/\/functiontranslator.com\/fr\/floor-precise\/","name":"Fonction FLOOR.PRECISE (PLANCHER.PRECIS) 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:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction FLOOR.PRECISE (PLANCHER.PRECIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/floor-precise\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/floor-precise\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/floor-precise\/#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.PRECIS"}]},{"@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\/6549","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=6549"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6549\/revisions"}],"predecessor-version":[{"id":29560,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6549\/revisions\/29560"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}