{"id":6428,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/plafond-precis\/"},"modified":"2021-02-26T08:02:51","modified_gmt":"2021-02-26T08:02:51","slug":"ceiling-precise","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/","title":{"rendered":"PLAFOND.PRECIS"},"content":{"rendered":"

Dans cet article, nous aborderons la fonction PLAFOND.PRECIS dans Microsoft Excel et Google Sheets. Nous verrons son utilit\u00e9, des exemples pratiques et comment elle simplifie le traitement des donn\u00e9es en arrondissant les nombres au multiple sup\u00e9rieur le plus proche, sans tenir compte de leur signe.<\/p>\n

Description et syntaxe<\/h2>\n

La fonction PLAFOND.PRECIS permet d’arrondir un nombre \u00e0 l’entier sup\u00e9rieur le plus proche, ou \u00e0 un multiple sp\u00e9cifique sup\u00e9rieur. Cette fonction se r\u00e9v\u00e8le tr\u00e8s utile dans le domaine financier, la gestion d’inventaire ou encore la planification, o\u00f9 il est crucial de ne pas g\u00e9rer de valeurs fractionnaires.<\/p>\n

Voici la syntaxe pour Excel et Google Sheets :<\/p>\n

 PLAFOND.PRECIS(nombre, [facteur]) <\/code> <\/pre>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir.<\/li>\n
  • facteur<\/strong> : Le multiple auquel arrondir le nombre. Ce param\u00e8tre est facultatif. S’il n’est pas sp\u00e9cifi\u00e9, il est consid\u00e9r\u00e9 comme \u00e9gal \u00e0 1.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
     =PLAFOND.PRECIS(4.3) retourne 5 =PLAFOND.PRECIS(-4.3) retourne -4 <\/code> <\/pre>\n
    Cas d’utilisation<\/h2>\n
    La fonction PLAFOND.PRECIS est applicable dans de nombreux sc\u00e9narios professionnels o\u00f9 un arrondi standard n’est pas suffisant.<\/p>\n
    Premier sc\u00e9nario : Calcul de packages<\/h2>\n
    Probl\u00e8me :<\/strong> Une entreprise souhaite emballer des produits en bo\u00eetes de 25 articles. Combien de bo\u00eetes sont n\u00e9cessaires pour emballer 249 articles ?<\/p>\n
    Solution :<\/strong><\/p>\n
     =PLAFOND.PRECIS(249\/25) <\/code> <\/pre>\n
    Explication : Diviser 249 par 25 donne 9.96, ce qui sugg\u00e9rerait normalement un besoin d’au moins 10 bo\u00eetes. PLAFOND.PRECIS arrondit ce chiffre \u00e0 10, confirmant ainsi que 10 bo\u00eetes suffisent.<\/p>\n
    Deuxi\u00e8me sc\u00e9nario : Heures de travail<\/h2>\n
    Probl\u00e8me :<\/strong> Les employ\u00e9s sont r\u00e9mun\u00e9r\u00e9s par intervalles de 15 minutes travaill\u00e9es. Si un employ\u00e9 travaille 67 minutes, comment le r\u00e9mun\u00e9rer ?<\/p>\n
    Solution :<\/strong><\/p>\n
     =PLAFOND.PRECIS(67\/15) * taux_horaire <\/code> <\/pre>\n
    Explication : En divisant 67 par 15 minutes, on obtient 4.47. PLAFOND.PRECIS arrondit ce nombre \u00e0 5. Le nombre de tranches de 15 minutes est ensuite multipli\u00e9 par le taux horaire pour calculer la r\u00e9mun\u00e9ration exacte de l\u2019employ\u00e9.<\/p>\n
    Ces exemples illustrent clairement l’utilit\u00e9 de la fonction PLAFOND.PRECIS dans diverses situations o\u00f9 un arrondi pr\u00e9cis au multiple sup\u00e9rieur est requis. Sa facilit\u00e9 d’int\u00e9gration en fait un outil indispensable pour les entreprises et les utilisateurs individuels qui cherchent \u00e0 pr\u00e9ciser leurs calculs et \u00e0 optimiser leurs processus logistiques.<\/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-6428","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction CEILING.PRECISE (PLAFOND.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CEILING.PRECISE (PLAFOND.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\/ceiling-precise\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CEILING.PRECISE (PLAFOND.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CEILING.PRECISE (PLAFOND.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\/ceiling-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:02:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CEILING.PRECISE (PLAFOND.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/\",\"name\":\"Fonction CEILING.PRECISE (PLAFOND.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:02:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CEILING.PRECISE (PLAFOND.PRECIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ceiling-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\":\"PLAFOND.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 CEILING.PRECISE (PLAFOND.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CEILING.PRECISE (PLAFOND.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\/ceiling-precise\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CEILING.PRECISE (PLAFOND.PRECIS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CEILING.PRECISE (PLAFOND.PRECIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CEILING.PRECISE (PLAFOND.PRECIS) 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\/ceiling-precise\/","url":"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/","name":"Fonction CEILING.PRECISE (PLAFOND.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:02:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CEILING.PRECISE (PLAFOND.PRECIS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ceiling-precise\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ceiling-precise\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ceiling-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":"PLAFOND.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\/6428","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=6428"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6428\/revisions"}],"predecessor-version":[{"id":29440,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6428\/revisions\/29440"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}