{"id":11091,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/receber\/"},"modified":"2021-02-25T17:27:55","modified_gmt":"2021-02-25T17:27:55","slug":"received","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/received\/","title":{"rendered":"RECEBER"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o RECEBIDO<\/h2>\n

Em MS Excel e Google Sheets, a fun\u00e7\u00e3o RECEBIDO \u00e9 fundamental para determinar o valor final que ser\u00e1 recebido por um t\u00edtulo de d\u00edvida totalmente amortizado em sua data de resgate. Essencial no setor financeiro, essa fun\u00e7\u00e3o \u00e9 particularmente valiosa para os profissionais que gerenciam investimentos em t\u00edtulos e obriga\u00e7\u00f5es.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe para a fun\u00e7\u00e3o RECEBIDO \u00e9 a seguinte:<\/p>\n

 RECEBIDO(data_de_emissao, data_de_vencimento, investimento, resgate, [base]) <\/code><\/pre>\n
    \n
  • data_de_emissao<\/strong>: A data na qual o t\u00edtulo foi emitido.<\/li>\n
  • data_de_vencimento<\/strong>: A data na qual o t\u00edtulo vencer\u00e1.<\/li>\n
  • investimento<\/strong>: O montante de dinheiro investido no t\u00edtulo.<\/li>\n
  • resgate<\/strong>: O valor que ser\u00e1 pago pelo t\u00edtulo na data de vencimento.<\/li>\n
  • base<\/strong> (opcional): O m\u00e9todo de contagem de dias utilizado (0 = 30\/360, 1 = real\/real, 2 = real\/360, 3 = real\/365).<\/li>\n<\/ul>\n
    Exemplo 1:<\/p>\n
     =RECEBIDO(\"01\/01\/2020\", \"31\/12\/2020\", 10000, 10500, 0) <\/code><\/pre>\n
    Neste exemplo, um t\u00edtulo emitido em 01 de janeiro de 2020 e com vencimento em 31 de dezembro de 2020, com um investimento inicial de R$10.000 e um valor de resgate de R$10.500, utilizando a base 30\/360, a fun\u00e7\u00e3o calcula o montante que ser\u00e1 recebido pelo investidor na data do vencimento.<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Caso 1: Planejamento de Retorno de Investimento<\/h3>\n
    Para um investidor que deseja entender o retorno total de um t\u00edtulo, precisando planejar suas finan\u00e7as futuras, suponha um investimento de R$20.000 em um t\u00edtulo que ter\u00e1 um resgate de R$22.000 em um ano, usando a base real\/365:<\/p>\n
     =RECEBIDO(\"01\/01\/2023\", \"31\/12\/2023\", 20000, 22000, 3) <\/code><\/pre>\n
    Esta f\u00f3rmula permite calcular o total que ser\u00e1 recebido ao final do per\u00edodo, auxiliando no planejamento financeiro futuro do investidor.<\/p>\n
    Caso 2: Compara\u00e7\u00e3o entre Investimentos<\/h3>\n
    Um gestor de fundos quer avaliar qual entre dois t\u00edtulos \u00e9 mais lucrativo:<\/p>\n\n\n\n\n
    T\u00edtulo<\/th>\nData de Emiss\u00e3o<\/th>\nData de Vencimento<\/th>\nInvestimento<\/th>\nResgate<\/th>\nBase<\/th>\nRecebido<\/th>\n<\/tr>\n
    T\u00edtulo A<\/td>\n01\/01\/2023<\/td>\n31\/12\/2024<\/td>\n15000<\/td>\n17000<\/td>\n1<\/td>\n=RECEBIDO(\"01\/01\/2023\", \"31\/12\/2024\", 15000, 17000, 1)<\/code><\/td>\n<\/tr>\n
    T\u00edtulo B<\/td>\n01\/01\/2023<\/td>\n30\/06\/2023<\/td>\n8000<\/td>\n9000<\/td>\n1<\/td>\n=RECEBIDO(\"01\/01\/2023\", \"30\/06\/2023\", 8000, 9000, 1)<\/code><\/td>\n<\/tr>\n<\/table>\n
    Este gestor pode usar a fun\u00e7\u00e3o RECEBIDO para calcular e comparar o retorno total dos dois t\u00edtulos, facilitando a tomada de uma decis\u00e3o informada sobre qual investimento oferece um retorno superior.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve o montante recebido no vencimento de um t\u00edtulo investido na totalidade<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[438],"tags":[],"class_list":["post-11091","post","type-post","status-publish","format-standard","hentry","category-financeira"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o RECEIVED (RECEBER) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RECEIVED (RECEBER) 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\/received\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o RECEIVED (RECEBER) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RECEIVED (RECEBER) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/received\/\" \/>\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:27:55+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 RECEIVED (RECEBER) 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\/received\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/received\/\",\"name\":\"Fun\u00e7\u00e3o RECEIVED (RECEBER) 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:27:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RECEIVED (RECEBER) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/received\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/received\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/received\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financeira\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/financeira\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RECEBER\"}]},{\"@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 RECEIVED (RECEBER) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RECEIVED (RECEBER) 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\/received\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o RECEIVED (RECEBER) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RECEIVED (RECEBER) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/received\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:27:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o RECEIVED (RECEBER) 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\/received\/","url":"https:\/\/functiontranslator.com\/pt-pt\/received\/","name":"Fun\u00e7\u00e3o RECEIVED (RECEBER) 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:27:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RECEIVED (RECEBER) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/received\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/received\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/received\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Financeira","item":"https:\/\/functiontranslator.com\/pt-pt\/financeira\/"},{"@type":"ListItem","position":3,"name":"RECEBER"}]},{"@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\/11091","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=11091"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11091\/revisions"}],"predecessor-version":[{"id":25920,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11091\/revisions\/25920"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}