{"id":6773,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/petite-valeur\/"},"modified":"2021-02-26T08:13:51","modified_gmt":"2021-02-26T08:13:51","slug":"small","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/small\/","title":{"rendered":"PETITE.VALEUR"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction PETITE.VALEUR dans Microsoft Excel et Google Sheets permet de retrouver la k-i\u00e8me plus petite valeur dans un ensemble de donn\u00e9es. Elle est extr\u00eamement utile dans l’analyse de donn\u00e9es pour extraire des informations statistiques telles que les valeurs minimales, m\u00e9dianes ou d’autres \u00e9l\u00e9ments class\u00e9s par taille. <\/p>\n

Syntaxe:<\/strong><\/p>\n

PETITE.VALEUR(plage, k)<\/code><\/pre>\n
    \n
  • plage<\/strong> : Correspond \u00e0 l’intervalle de cellules o\u00f9 la fonction cherchera la valeur.<\/li>\n
  • k<\/strong> : Indique la position de la valeur souhait\u00e9e, k=1 correspond \u00e0 la plus petite valeur, k=2 \u00e0 la deuxi\u00e8me plus petite, etc.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Pour illustrer l’utilisation de cette fonction, prenons un exemple simple.<\/p>\n\n\n\n\n\n\n
    A<\/th>\n<\/tr>\n
    10<\/td>\n<\/tr>\n
    20<\/td>\n<\/tr>\n
    5<\/td>\n<\/tr>\n
    15<\/td>\n<\/tr>\n<\/table>\n
    Pour d\u00e9terminer la deuxi\u00e8me plus petite valeur dans cette liste, la formule suivante serait utilis\u00e9e dans Excel ou Google Sheets :<\/p>\n
    =PETITE.VALEUR(A1:A4, 2)<\/code><\/pre>\n
    Cette formule retourne 10<\/strong>, qui est la deuxi\u00e8me plus petite valeur dans la plage A1:A4.<\/p>\n
    Sc\u00e9narios pratiques<\/h2>\n
    1. Analyse des r\u00e9sultats d’un examen<\/h3>\n
    Supposons que vous disposez d’une liste de scores de diff\u00e9rents \u00e9tudiants et que vous souhaitez identifier les trois plus faibles pour proposer des sessions de tutorat suppl\u00e9mentaires.<\/p>\n\n\n
    65<\/td>\n82<\/td>\n74<\/td>\n55<\/td>\n91<\/td>\n<\/tr>\n<\/table>\n
    Solution:<\/p>\n
    1\u00e8re plus basse note: =PETITE.VALEUR(A1:E1, 1) - R\u00e9sultat: 55 2\u00e8me plus basse note: =PETITE.VALEUR(A1:E1, 2) - R\u00e9sultat: 65 3\u00e8me plus basse note: =PETITE.VALEUR(A1:E1, 3) - R\u00e9sultat: 74<\/code><\/pre>\n
    2. S\u00e9lectionner des candidats pour une entrevue<\/h3>\n
    Imaginez que des scores sur une \u00e9chelle de 100 points sont assign\u00e9s aux candidatures pour un poste, et l’entreprise souhaite interviewer les 5 candidats ayant les scores les plus bas pour comprendre leur motivation.<\/p>\n\n\n
    88<\/td>\n70<\/td>\n65<\/td>\n55<\/td>\n90<\/td>\n75<\/td>\n60<\/td>\n<\/tr>\n<\/table>\n
    Solution:<\/p>\n
    1er score bas: =PETITE.VALEUR(A1:G1, 1) - R\u00e9sultat: 55 2\u00e8me score bas: =PETITE.VALEUR(A1:G1, 2) - R\u00e9sultat: 60 3\u00e8me score bas: =PETITE.VALEUR(A1:G1, 3) - R\u00e9sultat: 65 4\u00e8me score bas: =PETITE.VALEUR(A1:G1, 4) - R\u00e9sultat: 70 5\u00e8me score bas: =PETITE.VALEUR(A1:G1, 5) - R\u00e9sultat: 75<\/code><\/pre>\n
    Ces exemples illustrent comment la fonction PETITE.VALEUR peut \u00eatre utilis\u00e9e pour mener des analyses et effectuer des s\u00e9lections bas\u00e9es sur des crit\u00e8res num\u00e9riques dans de nombreux contextes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la k-i\u00e8me plus petite valeuR d\u2019une s\u00e9Rie de donn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[315],"tags":[],"class_list":["post-6773","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction SMALL (PETITE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SMALL (PETITE.VALEUR) 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\/small\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SMALL (PETITE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SMALL (PETITE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/small\/\" \/>\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:13:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SMALL (PETITE.VALEUR) 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\/small\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/small\/\",\"name\":\"Fonction SMALL (PETITE.VALEUR) 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:13:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SMALL (PETITE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/small\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/small\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/small\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiques\",\"item\":\"https:\/\/functiontranslator.com\/fr\/statistiques\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PETITE.VALEUR\"}]},{\"@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 SMALL (PETITE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SMALL (PETITE.VALEUR) 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\/small\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SMALL (PETITE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SMALL (PETITE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/small\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SMALL (PETITE.VALEUR) 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\/small\/","url":"https:\/\/functiontranslator.com\/fr\/small\/","name":"Fonction SMALL (PETITE.VALEUR) 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:13:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SMALL (PETITE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/small\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/small\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/small\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Statistiques","item":"https:\/\/functiontranslator.com\/fr\/statistiques\/"},{"@type":"ListItem","position":3,"name":"PETITE.VALEUR"}]},{"@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\/6773","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=6773"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6773\/revisions"}],"predecessor-version":[{"id":29783,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6773\/revisions\/29783"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}