{"id":6506,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdmin\/"},"modified":"2021-02-26T08:05:01","modified_gmt":"2021-02-26T08:05:01","slug":"dmin","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dmin\/","title":{"rendered":"BDMIN"},"content":{"rendered":"

Synth\u00e8se de la fonction de calcul du minimum dans une base de donn\u00e9es<\/h2>\n

La fonction DMIN, connue sous le nom de BDMIN dans Google Sheets (Feuilles de Calcul Google), est utilis\u00e9e pour trouver la valeur minimum dans une colonne d’une liste ou d’une base de donn\u00e9es qui r\u00e9pond \u00e0 certains crit\u00e8res.<\/p>\n

Description du fonctionnement<\/h2>\n

Cette fonction est particuli\u00e8rement utile pour traiter de grandes quantit\u00e9s de donn\u00e9es, permettant aux utilisateurs de filtrer et d’extraire des informations sp\u00e9cifiques bas\u00e9es sur des conditions d\u00e9finies. La syntaxe de la fonction est l\u00e9g\u00e8rement diff\u00e9rente entre Excel et Google Sheets, mais le concept reste le m\u00eame.<\/p>\n

Dans MS Excel :<\/p>\n

  DMIN(base_de_donn\u00e9es, champ, crit\u00e8res) <\/code> <\/pre>\n
Dans Google Sheets :<\/p>\n
  BDMIN(base_de_donn\u00e9es, champ, crit\u00e8res) <\/code> <\/pre>\n
    \n
  • base_de_donn\u00e9es<\/strong> : La plage de cellules qui fait la base de donn\u00e9es.<\/li>\n
  • champ<\/strong> : Le nom de la colonne dans la base de donn\u00e9es dont vous souhaitez trouver la valeur minimum. Il peut \u00eatre sp\u00e9cifi\u00e9 soit par le nom en en-t\u00eate de la colonne, soit par son index num\u00e9rique.<\/li>\n
  • crit\u00e8res<\/strong> : La plage de cellules qui contient les crit\u00e8res que les enregistrements de la base de donn\u00e9es doivent respecter pour \u00eatre pris en compte dans le calcul.<\/li>\n<\/ul>\n
    Exemples pratiques d’utilisation<\/h2>\n
    Examinez comment cette fonction peut \u00eatre appliqu\u00e9e dans deux sc\u00e9narios diff\u00e9rents pour am\u00e9liorer l’analyse de donn\u00e9es.<\/p>\n
    Exemple 1 : Trouver le salaire minimum dans un d\u00e9partement sp\u00e9cifique<\/h2>\n
    Imaginez que vous avez une base de donn\u00e9es des employ\u00e9s avec les colonnes \u00ab\u00a0Nom\u00a0\u00bb, \u00ab\u00a0D\u00e9partement\u00a0\u00bb et \u00ab\u00a0Salaire\u00a0\u00bb. Vous voulez trouver le salaire minimum dans le d\u00e9partement \u00ab\u00a0Marketing\u00a0\u00bb.<\/p>\n
      =DMIN(A1:C100; \"Salaire\"; A1:A2) <\/code> <\/pre>\n
    O\u00f9 ‘A1:C100’ est la plage de la base de donn\u00e9es, \u00ab\u00a0Salaire\u00a0\u00bb indique la colonne dont vous cherchez le minimum, et ‘A1:A2’ contient les crit\u00e8res sp\u00e9cifiques, ici \u00ab\u00a0D\u00e9partement = Marketing\u00a0\u00bb.<\/p>\n
    Exemple 2 : Application pour l’\u00e9ducation<\/h2>\n
    Un directeur d’\u00e9cole souhaite trouver la note minimale en maths parmi les \u00e9l\u00e8ves de terminale pour \u00e9valuer les besoins en tutorat. La base de donn\u00e9es contient les colonnes \u00ab\u00a0\u00c9l\u00e8ve\u00a0\u00bb, \u00ab\u00a0Niveau\u00a0\u00bb, \u00ab\u00a0Mati\u00e8re\u00a0\u00bb, et \u00ab\u00a0Note\u00a0\u00bb.<\/p>\n
      =DMIN(A1:D200; \"Note\"; G1:H2) <\/code> <\/pre>\n
    Dans cet exemple, ‘A1:D200’ repr\u00e9sente la base de donn\u00e9es. \u00ab\u00a0Note\u00a0\u00bb est la colonne pour laquelle nous voulons trouver la valeur minimum. ‘G1:H2’ repr\u00e9senterait une plage contenant les crit\u00e8res tels que \u00ab\u00a0Niveau = Terminale\u00a0\u00bb et \u00ab\u00a0Mati\u00e8re = Maths\u00a0\u00bb.<\/p>\n
    Ces exemples montrent comment la fonction DMIN, ou BDMIN, peut \u00eatre exploit\u00e9e pour extraire des informations pr\u00e9cises bas\u00e9es sur des crit\u00e8res d\u00e9finis, facilitant ainsi l\u2019analyse sectorielle ou globale des donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR minimale des entR\u00e9es de base de donn\u00e9es s\u00e9lectionn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[322],"tags":[],"class_list":["post-6506","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DMIN (BDMIN) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DMIN (BDMIN) 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\/dmin\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DMIN (BDMIN) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DMIN (BDMIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dmin\/\" \/>\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:05:01+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DMIN (BDMIN) 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\/dmin\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dmin\/\",\"name\":\"Fonction DMIN (BDMIN) 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:05:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DMIN (BDMIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dmin\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es\",\"item\":\"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDMIN\"}]},{\"@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 DMIN (BDMIN) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DMIN (BDMIN) 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\/dmin\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DMIN (BDMIN) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DMIN (BDMIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dmin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DMIN (BDMIN) 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\/dmin\/","url":"https:\/\/functiontranslator.com\/fr\/dmin\/","name":"Fonction DMIN (BDMIN) 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:05:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DMIN (BDMIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dmin\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es","item":"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/"},{"@type":"ListItem","position":3,"name":"BDMIN"}]},{"@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\/6506","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=6506"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6506\/revisions"}],"predecessor-version":[{"id":29518,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6506\/revisions\/29518"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}