{"id":14169,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/cantidad-recibida\/"},"modified":"2021-02-26T08:56:52","modified_gmt":"2021-02-26T08:56:52","slug":"received","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/received\/","title":{"rendered":"CANTIDAD.RECIBIDA"},"content":{"rendered":"

Introducci\u00f3n a la Funci\u00f3n CANTIDAD.RECIBIDA<\/h2>\n

La funci\u00f3n CANTIDAD.RECIBIDA en MS Excel y Google Sheets es utilizada para calcular el monto total que se recibe tras un per\u00edodo determinado en una inversi\u00f3n con pagos peri\u00f3dicos y una tasa de inter\u00e9s constante. Esta funci\u00f3n es esencial en el sector financiero, ideal para calcular pensiones, anualidades o cualquier inversi\u00f3n que requiera pagos regulares a lo largo del tiempo.<\/p>\n

Sintaxis y Ejemplos de Uso<\/h2>\n

La sintaxis de la funci\u00f3n CANTIDAD.RECIBIDA es la siguiente:<\/p>\n

CANTIDAD.RECIBIDA(nper, pgo, va, [tipo])<\/code><\/pre>\n
    \n
  • nper:<\/strong> n\u00famero total de pagos de la inversi\u00f3n.<\/li>\n
  • pgo:<\/strong> monto del pago en cada per\u00edodo.<\/li>\n
  • va:<\/strong> valor actual o monto principal de la inversi\u00f3n.<\/li>\n
  • tipo:<\/strong> (opcional) especifica cu\u00e1ndo se realizan los pagos. 0=final del per\u00edodo, 1=comienzo del per\u00edodo.<\/li>\n<\/ul>\n
    Ejemplo 1:<\/em> Para calcular la cantidad recibida de una inversi\u00f3n con 20 pagos peri\u00f3dicos de $1,000 cada uno y un valor actual de $15,000, con pagos al final de cada per\u00edodo, usar\u00edamos:<\/p>\n
    =CANTIDAD.RECIBIDA(20, 1000, 15000, 0)<\/code><\/pre>\n
    Este c\u00e1lculo nos proporcionar\u00e1 el monto total recibido al final del per\u00edodo de inversi\u00f3n con los par\u00e1metros especificados.<\/p>\n
    Ejemplo 2:<\/em> Para calcular con pagos al inicio de cada per\u00edodo, modificamos el tipo a 1:<\/p>\n
    =CANTIDAD.RECIBIDA(20, 1000, 15000, 1)<\/code><\/pre>\n
    Escenarios Pr\u00e1cticos de Aplicaci\u00f3n<\/h2>\n
    Planificaci\u00f3n de una Jubilaci\u00f3n<\/b>
     Si est\u00e1s planificando tu jubilaci\u00f3n y deseas saber cu\u00e1nto podr\u00e1s retirar cada mes considerando lo que has acumulado, puedes emplear la funci\u00f3n CANTIDAD.RECIBIDA para estimar el total que recibir\u00e1s al final de la jubilaci\u00f3n. Por ejemplo, para retirar $1,200 mensuales durante 20 a\u00f1os (240 meses), con un capital inicial de $300,000 y los pagos al inicio de cada mes, usar\u00edas: <\/p>\n
    =CANTIDAD.RECIBIDA(240, 1200, 300000, 1)<\/code><\/pre>\n<\/p>\n
    C\u00e1lculo de Retorno en Anualidades<\/b>
     Los inversionistas en anualidades que desean conocer el total que recibir\u00e1n despu\u00e9s de hacer pagos mensuales pueden aplicar esta funci\u00f3n. Por ejemplo: <\/p>\n
    =CANTIDAD.RECIBIDA(120, 500, 50000, 0)<\/code><\/pre>\n
     Este caso representa un pago de $500 mensuales durante 10 a\u00f1os (120 meses) con un capital inicial de $50,000, y los pagos se efect\u00faan al final de cada mes.<\/p>\n
    Con estos ejemplos, queda claro c\u00f3mo la funci\u00f3n CANTIDAD.RECIBIDA es una herramienta clave para la planificaci\u00f3n y la gesti\u00f3n financiera eficaz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la cantidad recibida al vencimiento de un valor burs\u00e1til completamente invertido<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[536],"tags":[],"class_list":["post-14169","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/received\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/received\/\" \/>\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:56:52+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\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\/es\/received\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/received\/\",\"name\":\"Funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:56:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/received\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/received\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/received\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finanzas\",\"item\":\"https:\/\/functiontranslator.com\/es\/finanzas\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CANTIDAD.RECIBIDA\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/received\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/received\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:56:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/received\/","url":"https:\/\/functiontranslator.com\/es\/received\/","name":"Funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:56:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n RECEIVED (CANTIDAD.RECIBIDA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/received\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/received\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/received\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Finanzas","item":"https:\/\/functiontranslator.com\/es\/finanzas\/"},{"@type":"ListItem","position":3,"name":"CANTIDAD.RECIBIDA"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14169"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14169\/revisions"}],"predecessor-version":[{"id":30260,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14169\/revisions\/30260"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}