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

Syntaxe et description<\/h2>\n

La fonction PLAFOND.MATH<\/code> dans Excel et Google Sheets est con\u00e7ue pour arrondir un nombre jusqu’\u00e0 l’entier sup\u00e9rieur le plus proche bas\u00e9 sur un multiple sp\u00e9cifique. Elle se r\u00e9v\u00e8le extr\u00eamement utile pour la normalisation des donn\u00e9es et les calculs financiers o\u00f9 un type d’arrondi particulier est requis.<\/p>\n

=PLAFOND.MATH(nombre; [signif]; [mode])<\/code><\/pre>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir.<\/li>\n
  • signif<\/strong> (facultatif) : Le multiple \u00e0 utiliser pour l’arrondissement. La valeur par d\u00e9faut est 1.<\/li>\n
  • mode<\/strong> (facultatif) : Un param\u00e8tre qui d\u00e9termine la direction de l’arrondi. Par d\u00e9faut, ou si le mode est z\u00e9ro, le nombre est arrondi vers l’entier sup\u00e9rieur. Si le mode est non-z\u00e9ro, l’arrondi prend en compte le signe du nombre (positif ou n\u00e9gatif), arrondissant vers le plus proche sup\u00e9rieur pour les nombres positifs et le plus proche inf\u00e9rieur pour les nombres n\u00e9gatifs.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =PLAFOND.MATH(6.7) \/\/ Renvoie 7 =PLAFOND.MATH(-2.5; 2) \/\/ Renvoie -2 =PLAFOND.MATH(7.2; 0.5) \/\/ Renvoie 7.5<\/code><\/pre>\n
    Sc\u00e9narios pratiques d’utilisation<\/h2>\n
    Examinons quelques sc\u00e9narios r\u00e9els d’utilisation de la fonction PLAFOND.MATH<\/code>.<\/p>\n
    Pr\u00e9paration d’un budget<\/h2>\n
    Imaginez que vous devez pr\u00e9parer un budget pour un \u00e9v\u00e9nement et que vous avez besoin d’arrondir les co\u00fbts au dollar sup\u00e9rieur pour simplifier les calculs financiers. Consid\u00e9rez la liste suivante de co\u00fbts initiaux :<\/p>\n
    Colonne A Colonne B Article Co\u00fbt Papier 23.45 Stylos 8.29 Caf\u00e9 11.73<\/code><\/pre>\n
    Pour arrondir ces co\u00fbts, utilisez la formule suivante :<\/p>\n
    =PLAFOND.MATH(B2; 1)<\/code><\/pre>\n
    En appliquant cette formule sur toute la colonne des co\u00fbts, vous obtenez :<\/p>\n
    Colonne A Colonne B Article Co\u00fbt Papier 24 Stylos 9 Caf\u00e9 12<\/code><\/pre>\n
    Planification de la production<\/h2>\n
    Dans un contexte de fabrication, les mat\u00e9riaux doivent souvent \u00eatre utilis\u00e9s en quantit\u00e9s enti\u00e8res, m\u00eame si les mesures initiales ne le sont pas. Supposons que des commandes demandent des longueurs sp\u00e9cifiques de tissu :<\/p>\n
    Commande Longueur requise (cm) Commande 1 250.5 Commande 2 123.9 Commande 3 456.1<\/code><\/pre>\n
    La formule d’arrondissement suivante assure l’utilisation optimale des mat\u00e9riaux :<\/p>\n
    =PLAFOND.MATH(B2; 1)<\/code><\/pre>\n
    Cette application garantit que chaque commande est pr\u00e9par\u00e9e avec la quantit\u00e9 exacte de mat\u00e9riel n\u00e9cessaire, maximisant l’utilisation des ressources sans gaspillage:<\/p>\n
    Commande Longueur requise (cm) Commande 1 251 Commande 2 124 Commande 3 457<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
    Arrondit un nombre Au nombre entier sup\u00e9rieur le plus proche ou Au multiple le plus proche de l\u2019Argument pr\u00e9cision 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-6427","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction CEILING.MATH (PLAFOND.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CEILING.MATH (PLAFOND.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\/ceiling-math\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CEILING.MATH (PLAFOND.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CEILING.MATH (PLAFOND.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\/ceiling-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:02:50+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.MATH (PLAFOND.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\/ceiling-math\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ceiling-math\/\",\"name\":\"Fonction CEILING.MATH (PLAFOND.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:02:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CEILING.MATH (PLAFOND.MATH) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ceiling-math\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ceiling-math\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ceiling-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\":\"PLAFOND.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 CEILING.MATH (PLAFOND.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CEILING.MATH (PLAFOND.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\/ceiling-math\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CEILING.MATH (PLAFOND.MATH) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CEILING.MATH (PLAFOND.MATH) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ceiling-math\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CEILING.MATH (PLAFOND.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\/ceiling-math\/","url":"https:\/\/functiontranslator.com\/fr\/ceiling-math\/","name":"Fonction CEILING.MATH (PLAFOND.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:02:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CEILING.MATH (PLAFOND.MATH) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ceiling-math\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ceiling-math\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ceiling-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":"PLAFOND.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\/6427","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=6427"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6427\/revisions"}],"predecessor-version":[{"id":29439,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6427\/revisions\/29439"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}