{"id":11120,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/menor\/"},"modified":"2021-02-25T17:29:23","modified_gmt":"2021-02-25T17:29:23","slug":"small","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/small\/","title":{"rendered":"MENOR"},"content":{"rendered":"

A fun\u00e7\u00e3o MENOR, dispon\u00edvel tanto no Microsoft Excel quanto no Google Planilhas, \u00e9 fundamental para identificar o n-\u00e9simo menor valor dentre um conjunto de dados. Esta fun\u00e7\u00e3o \u00e9 particularmente valiosa em an\u00e1lises estat\u00edsticas, como na determina\u00e7\u00e3o de quartis ou decis, ou simplesmente para filtrar os menores valores em uma lista. Neste guia, exploraremos como utilizar a fun\u00e7\u00e3o MENOR por meio de exemplos pr\u00e1ticos e discutiremos cen\u00e1rios comuns de aplica\u00e7\u00e3o.<\/p>\n

Entendendo a Sintaxe da Fun\u00e7\u00e3o MENOR<\/h2>\n

A sintaxe b\u00e1sica da fun\u00e7\u00e3o MENOR \u00e9:<\/p>\n

=MENOR(intervalo; n)<\/code><\/pre>\n
    \n
  • intervalo<\/strong>: Conjunto de c\u00e9lulas alvo da fun\u00e7\u00e3o.<\/li>\n
  • n<\/strong>: A posi\u00e7\u00e3o do valor desejado no conjunto, quando ordenados do menor para o maior.<\/li>\n<\/ul>\n
    Por exemplo, para encontrar o terceiro menor valor num conjunto de n\u00fameros de A1 a A10, voc\u00ea utilizaria:<\/p>\n
    =MENOR(A1:A10; 3)<\/code><\/pre>\n
    Exemplos de Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    A seguir, apresentamos dois cen\u00e1rios pr\u00e1ticos onde a fun\u00e7\u00e3o MENOR pode ser extremamente \u00fatil:<\/p>\n
    Cen\u00e1rio 1: An\u00e1lise de Testes Acad\u00eamicos<\/h2>\n
    Considere um professor que deseja descobrir os dois menores resultados de uma prova aplicada a 20 estudantes, com as notas listadas de A1 a A20. A aplica\u00e7\u00e3o seria:<\/p>\n
    =MENOR(A1:A20; 1) \/\/ Para descobrir a menor nota =MENOR(A1:A20; 2) \/\/ Para encontrar a segunda menor nota<\/code><\/pre>\n
    Essas f\u00f3rmulas retornar\u00e3o, respectivamente, a menor e a segunda menor nota no intervalo especificado, auxiliando o professor a identificar os alunos que podem necessitar de mais suporte acad\u00eamico.<\/p>\n
    Cen\u00e1rio 2: Sele\u00e7\u00e3o de Produtos com Menores Pre\u00e7os<\/h2>\n
    Imagine um gerente de compras que deseja selecionar os tr\u00eas produtos mais baratos de uma lista de 50 itens, catalogados na coluna B1:B50. Ele usaria a seguinte sintaxe:<\/p>\n
    =MENOR(B1:B50; 1) =MENOR(B1:B50; 2) =MENOR(B1:B50; 3)<\/code><\/pre>\n
      \n
    • Essas f\u00f3rmulas ir\u00e3o identificar os pre\u00e7os dos tr\u00eas produtos mais econ\u00f4micos, facilitando ao gerente a otimiza\u00e7\u00e3o de suas escolhas com base em restri\u00e7\u00f5es or\u00e7ament\u00e1rias.<\/li>\n<\/ul>\n
      Com a fun\u00e7\u00e3o MENOR, profissionais de diversas \u00e1reas podem simplificar an\u00e1lises e processos decis\u00f3rios, concentrando-se nos valores mais baixos de um conjunto de dados. Isso demonstra a versatilidade e aplicabilidade pr\u00e1tica desta fun\u00e7\u00e3o tanto no Excel quanto no Google Planilhas.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devolve o menor valor en\u00e9simo de um conjunto de dados<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442],"tags":[],"class_list":["post-11120","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SMALL (MENOR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/small\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SMALL (MENOR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/small\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:29:23+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/small\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/small\/\",\"name\":\"Fun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:29:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SMALL (MENOR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/small\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/small\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/small\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estat\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MENOR\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SMALL (MENOR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/small\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SMALL (MENOR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/small\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:29:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/small\/","url":"https:\/\/functiontranslator.com\/pt-pt\/small\/","name":"Fun\u00e7\u00e3o SMALL (MENOR) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:29:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SMALL (MENOR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/small\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/small\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/small\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Estat\u00edstica","item":"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/"},{"@type":"ListItem","position":3,"name":"MENOR"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11120"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11120\/revisions"}],"predecessor-version":[{"id":25949,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11120\/revisions\/25949"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}