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

Description de la fonction PLAFOND<\/h2>\n

La fonction PLAFOND arrondit un nombre donn\u00e9 au multiple sup\u00e9rieur le plus proche de celui sp\u00e9cifi\u00e9. Elle est particuli\u00e8rement pratique pour normaliser les valeurs selon des unit\u00e9s ou multiples standards requis.<\/p>\n

Syntaxe et Exemples<\/h2>\n

La syntaxe de la fonction PLAFOND dans Excel et Google Sheets est :<\/p>\n

=PLAFOND(nombre; multiple)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir.<\/li>\n
  • multiple<\/strong> : Le multiple de r\u00e9f\u00e9rence pour l’arrondi.<\/li>\n<\/ul>\n
    Exemple 1 :<\/strong> Pour arrondir le nombre 3.7 au multiple de 2 le plus proche, utilisez :<\/p>\n
    =PLAFOND(3.7; 2)<\/code><\/pre>\n
    Cette formule renvoie 4, car 4 est le multiple de 2 le plus proche et sup\u00e9rieur \u00e0 3.7.<\/p>\n
    Exemple 2 :<\/strong> Pour arrondir 155 au multiple de 10 le plus proche, utilisez :<\/p>\n
    =PLAFOND(155; 10)<\/code><\/pre>\n
    Cela donne 160.<\/p>\n
    Sc\u00e9narios pratiques d’application<\/h2>\n
    Voici quelques exemples concrets d’utilisation de la fonction PLAFOND :<\/p>\n
    Sc\u00e9nario 1 : Arrondissement des heures dans une feuille de temps<\/h2>\n
    Pour calculer un paiement bas\u00e9 sur des heures de travail arrondies au quart d’heure le plus proche, voici les heures enregistr\u00e9es :<\/p>\n
    7.58, 4.12, 9.93<\/code><\/pre>\n
    Utilisez la formule ci-dessous pour arrondir ces heures :<\/p>\n
    =PLAFOND(A2; 0.25)<\/code><\/pre>\n
    o\u00f9 A2 repr\u00e9sente le temps travaill\u00e9. R\u00e9p\u00e9tez pour chaque enregistrement pertinent.<\/p>\n\n\n\n\n\n
    Heure Originale<\/th>\nHeure Arrondie<\/th>\n<\/tr>\n
    7.58<\/td>\n=PLAFOND(7.58; 0.25)<\/td>\n<\/tr>\n
    4.12<\/td>\n=PLAFOND(4.12; 0.25)<\/td>\n<\/tr>\n
    9.93<\/td>\n=PLAFOND(9.93; 0.25)<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9nario 2 : Arrondissement des prix aux multiplicit\u00e9s mon\u00e9taires standard<\/h2>\n
    Un magasin arrondit tous ses prix au nickel (0.05$) le plus proche. Voici quelques exemples de prix initiaux :<\/p>\n
    3.23$, 4.88$, 2.41$<\/code><\/pre>\n
    Pour arrondir ces prix, utilisez :<\/p>\n
    =PLAFOND(A2; 0.05)<\/code><\/pre>\n
    O\u00f9 A2 indique le prix. Ce processus doit \u00eatre r\u00e9p\u00e9t\u00e9 pour chaque prix list\u00e9.<\/p>\n\n\n\n\n\n
    Prix Original<\/th>\nPrix Arrondi<\/th>\n<\/tr>\n
    3.23$<\/td>\n=PLAFOND(3.23; 0.05)<\/td>\n<\/tr>\n
    4.88$<\/td>\n=PLAFOND(4.88; 0.05)<\/td>\n<\/tr>\n
    2.41$<\/td>\n=PLAFOND(2.41; 0.05)<\/td>\n<\/tr>\n<\/table>\n
    En conclusion, la fonction PLAFOND est extr\u00eamement utile pour s’assurer que les valeurs r\u00e9pondent \u00e0 des crit\u00e8res de multiples sp\u00e9cifiques, que ce soit dans des contextes financiers, des gestionnaires de temps de travail, ou tout autre domaine n\u00e9cessitant une normalisation pr\u00e9cise.<\/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<\/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-6426","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction CEILING (PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CEILING (PLAFOND) 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\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CEILING (PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CEILING (PLAFOND) 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\/\" \/>\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:48+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 (PLAFOND) 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\/ceiling\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ceiling\/\",\"name\":\"Fonction CEILING (PLAFOND) 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:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CEILING (PLAFOND) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ceiling\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ceiling\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ceiling\/#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\"}]},{\"@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 (PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CEILING (PLAFOND) 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\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CEILING (PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CEILING (PLAFOND) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ceiling\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CEILING (PLAFOND) 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\/ceiling\/","url":"https:\/\/functiontranslator.com\/fr\/ceiling\/","name":"Fonction CEILING (PLAFOND) 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:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CEILING (PLAFOND) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ceiling\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ceiling\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ceiling\/#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"}]},{"@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\/6426","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=6426"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6426\/revisions"}],"predecessor-version":[{"id":29438,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6426\/revisions\/29438"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}