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

Description de la Fonction<\/h2>\n

La fonction ISO.PLAFOND<\/code> dans Excel et ISO.CEILING<\/code> dans Google Sheets permet d’arrondir un nombre au multiple sup\u00e9rieur sp\u00e9cifi\u00e9, conform\u00e9ment \u00e0 la norme ISO. Cette fonction se distingue de la fonction PLAFOND<\/code> standard car elle round syst\u00e9matiquement vers le multiple sup\u00e9rieur, ce qui est particuli\u00e8rement utile dans des environnements o\u00f9 la conformit\u00e9 et la pr\u00e9cision sont critiques, comme dans le secteur financier ou r\u00e9glementaire.<\/p>\n

Syntaxe<\/h2>\n

Dans Excel : <\/p>\n

=ISO.PLAFOND(nombre, multiple)<\/code><\/pre>\n
 Dans Google Sheets : <\/p>\n
=ISO.CEILING(nombre, multiple)<\/code><\/pre>\n<\/p>\n
    \n
  • nombre<\/strong> : Le nombre \u00e0 arrondir.<\/li>\n
  • multiple<\/strong> : Le multiple auquel le nombre doit \u00eatre arrondi.<\/li>\n<\/ul>\n
    Si le multiple<\/code> n’est pas sp\u00e9cifi\u00e9, il prend par d\u00e9faut la valeur 1.<\/p>\n
    Exemples<\/h2>\n\n\n\n\n\n
    Formule<\/th>\nR\u00e9sultat<\/th>\nDescription<\/th>\n<\/tr>\n
    \n
    =ISO.PLAFOND(4.3, 2)<\/code><\/pre>\n<\/td>\n
    		6<\/td>\nArrondit 4.3 au multiple de 2 le plus proche, qui est 6.<\/td>\n<\/tr>\n
    \n
    =ISO.PLAFOND(-3.7, 2)<\/code><\/pre>\n<\/td>\n
    		-4<\/td>\nArrondit -3.7 au multiple de 2 le plus proche vers z\u00e9ro, soit -4.<\/td>\n<\/tr>\n
    \n
    =ISO.CEILING(7.5)<\/code><\/pre>\n<\/td>\n
    		8<\/td>\nDans Google Sheets, arrondit 7.5 au multiple de 1 le plus proche, soit 8.<\/td>\n<\/tr>\n<\/table>\n
    Applications Pratiques<\/h2>\n
    Premier Exemple : Pr\u00e9paration de commandes en lots<\/p>\n
     
    Supposons une entreprise devant commander des pi\u00e8ces par lots de 15. Pour une demande de 37 pi\u00e8ces, le calcul du nombre de lots n\u00e9cessaires est le suivant :<\/p> 
    Formule : =ISO.PLAFOND(37, 15)<\/code><\/p> 
    R\u00e9sultat : 45<\/p> 
    Il faut donc commander 45 pi\u00e8ces pour r\u00e9pondre \u00e0 une demande de 37 pi\u00e8ces, en arrondissant au multiple de 15 le plus proche.<\/p> <\/pre>\n
    Deuxi\u00e8me Exemple : Calcul de temps en heures facturables<\/p>\n
     
    Un consultant facture son temps par tranches de 30 minutes. Pour une t\u00e2che effectu\u00e9e en 1 heure et 47 minutes, le temps facturable s'\u00e9tablit comme suit :<\/p> 
    Formule : =ISO.CEILING(1.783, 0.5)<\/code> dans Google Sheets<\/p> 
    R\u00e9sultat : 2 heures<\/p> 
    Cela correspond \u00e0 arrondir 1.783 heures (environ 1 heure et 47 minutes) au multiple de 0.5 heures le plus proche, r\u00e9sultant en 2 heures facturables.<\/p> <\/pre>\n","protected":false},"excerpt":{"rendered":"
    Renvoie un nombRe aRRondi 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-6633","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction ISO.CEILING (ISO.PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ISO.CEILING (ISO.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\/iso-ceiling\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ISO.CEILING (ISO.PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ISO.CEILING (ISO.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\/iso-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:09:12+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ISO.CEILING (ISO.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\/iso-ceiling\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/iso-ceiling\/\",\"name\":\"Fonction ISO.CEILING (ISO.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:09:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ISO.CEILING (ISO.PLAFOND) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/iso-ceiling\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/iso-ceiling\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/iso-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\":\"ISO.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 ISO.CEILING (ISO.PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ISO.CEILING (ISO.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\/iso-ceiling\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ISO.CEILING (ISO.PLAFOND) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ISO.CEILING (ISO.PLAFOND) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/iso-ceiling\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ISO.CEILING (ISO.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\/iso-ceiling\/","url":"https:\/\/functiontranslator.com\/fr\/iso-ceiling\/","name":"Fonction ISO.CEILING (ISO.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:09:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ISO.CEILING (ISO.PLAFOND) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/iso-ceiling\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/iso-ceiling\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/iso-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":"ISO.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\/6633","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=6633"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6633\/revisions"}],"predecessor-version":[{"id":29644,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6633\/revisions\/29644"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}