{"id":6674,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/arrondi-au-multiple\/"},"modified":"2021-02-26T08:10:39","modified_gmt":"2021-02-26T08:10:39","slug":"mround","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/mround\/","title":{"rendered":"ARRONDI.AU.MULTIPLE"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction MROUND<\/code> dans Microsoft Excel et ARRONDI.AU.MULTIPLE<\/code> dans Google Sheets permettent d’arrondir un nombre \u00e0 un multiple sp\u00e9cifique d’un autre nombre. Cette fonction s’av\u00e8re \u00eatre un outil pr\u00e9cieux pour la gestion financi\u00e8re, la planification de production, et dans toute situation o\u00f9 des r\u00e9sultats num\u00e9riques pr\u00e9cis sont requis.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe pour Microsoft Excel est :<\/p>\n

MROUND(nombre, multiple)<\/code><\/pre>\n
Et pour Google Sheets :<\/p>\n
ARRONDI.AU.MULTIPLE(nombre, multiple)<\/code><\/pre>\n
    \n
  • nombre<\/code> : Le nombre que vous souhaitez arrondir.<\/li>\n
  • multiple<\/code> : Le multiple auquel vous voulez arrondir le nombre.<\/li>\n<\/ul>\n
    Exemple :<\/strong><\/p>\n
    =MROUND(10, 3) \/\/ R\u00e9sultat : 9<\/code><\/pre>\n
    Cet exemple illustre comment le nombre 10 est arrondi au multiple le plus proche de 3, r\u00e9sultant en 9.<\/p>\n
    Exemples pratiques d’utilisation<\/h2>\n
    Ci-dessous, quelques sc\u00e9narios o\u00f9 l’utilisation de MROUND<\/code> est pertinente.<\/p>\n
    Sc\u00e9nario 1: Gestion financi\u00e8re<\/h2>\n
    Imaginons que vous ayez une liste de prix avant application de la taxe que vous souhaitiez arrondir au multiple de 0.05, une pratique courante dans la fixation des prix.<\/p>\n\n\n\n\n
    Prix avant taxe<\/th>\nPrix arrondi<\/th>\n<\/tr>\n
    14.87<\/td>\n=MROUND(14.87, 0.05)<\/td>\n<\/tr>\n
    23.11<\/td>\n=MROUND(23.11, 0.05)<\/td>\n<\/tr>\n<\/table>\n
    Par exemple, 14.87 arrondi au multiple de 0.05 devient 14.85 et 23.11 devient 23.10. Cette m\u00e9thode simplifie les calculs ult\u00e9rieurs des prix avec taxe inclus.<\/p>\n
    Sc\u00e9nario 2: Planification de la production<\/h2>\n
    Dans le cas d’une entreprise qui fabrique des pi\u00e8ces uniquement par lots de 10, si une commande n’est pas un multiple de 10, elle devra \u00eatre arrondie \u00e0 l’aide de MROUND<\/code>.<\/p>\n
    =MROUND(312, 10) \/\/ R\u00e9sultat : 310<\/code><\/pre>\n
    Cet ajustement implique que pour une commande de 312 pi\u00e8ces, la production sera planifi\u00e9e pour 310 pi\u00e8ces afin de respecter les contraintes de production par lots. Cela optimise l’efficacit\u00e9 de la production et minimise les pertes de ressources.<\/p>\n
     This format accurately reflects the functionality of `MROUND` and `ARRONDI.AU.MULTIPLE` in both Microsoft Excel and Google Sheets, presenting the information in a clear and professional manner.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Donne l\u2019arronDi D\u2019un nombre au multiple sp\u00e9cifi\u00e9<\/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-6674","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction MROUND (ARRONDI.AU.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MROUND (ARRONDI.AU.MULTIPLE) 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\/mround\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MROUND (ARRONDI.AU.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MROUND (ARRONDI.AU.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/mround\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:10:39+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MROUND (ARRONDI.AU.MULTIPLE) 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\/mround\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/mround\/\",\"name\":\"Fonction MROUND (ARRONDI.AU.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:10:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MROUND (ARRONDI.AU.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/mround\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/mround\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/mround\/#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\":\"ARRONDI.AU.MULTIPLE\"}]},{\"@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 MROUND (ARRONDI.AU.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MROUND (ARRONDI.AU.MULTIPLE) 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\/mround\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MROUND (ARRONDI.AU.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MROUND (ARRONDI.AU.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/mround\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:10:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MROUND (ARRONDI.AU.MULTIPLE) 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\/mround\/","url":"https:\/\/functiontranslator.com\/fr\/mround\/","name":"Fonction MROUND (ARRONDI.AU.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:10:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MROUND (ARRONDI.AU.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/mround\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/mround\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/mround\/#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":"ARRONDI.AU.MULTIPLE"}]},{"@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\/6674","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=6674"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6674\/revisions"}],"predecessor-version":[{"id":29685,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6674\/revisions\/29685"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}