{"id":548,"date":"2023-10-24T01:59:08","date_gmt":"2023-10-24T01:59:08","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/omitido\/"},"modified":"2023-12-25T10:28:38","modified_gmt":"2023-12-25T10:28:38","slug":"omitido","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/omitido\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4226851330\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>La funci\u00f3n VBA RATE figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve la tasa de inter\u00e9s por per\u00edodo (con igual flujo de efectivo) para un pr\u00e9stamo o inversi\u00f3n.<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>TASA(Nper, Pmt, Pv, [Fv], [Vence], [Guess])<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Nper<\/strong> : El n\u00famero de per\u00edodos para reembolsar el pr\u00e9stamo o la inversi\u00f3n.<\/li>\n<li> <strong>Pmt<\/strong> : La cantidad fija de pago por per\u00edodo.<\/li>\n<li> <strong>PV<\/strong> : El valor actual de la inversi\u00f3n o pr\u00e9stamo.<\/li>\n<li> <strong>[FV]<\/strong> : El valor futuro del pr\u00e9stamo\/inversi\u00f3n (este es un argumento opcional y, si se omite, VBA toma 0 de forma predeterminada).<\/li>\n<li> <strong>[Vence]<\/strong> : define si el pago vence al inicio o al final del per\u00edodo, use 0 para el final del per\u00edodo y 1 para el inicio del per\u00edodo [Este es un argumento opcional y, si se omite, VBA toma el final del per\u00edodo de forma predeterminada] .<\/li>\n<li> <strong>[Conjetura]<\/strong> : una estimaci\u00f3n inicial (conjetura) de cu\u00e1l ser\u00e1 la TIR [Este es un argumento opcional y, si se omite, VBA toma el 10% (=0,1) de forma predeterminada].<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA RATE, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-rate-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-rate-function\" width=\"838\" height=\"438\"><\/figure>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_RATE() Range(\"A8\") = Rate(60, -1200, 0, 98000, 1) * 12 End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior hemos usado TASA para calcular la tasa de inter\u00e9s de la inversi\u00f3n donde tenemos 60 meses, 1200 del pago mensual y 98000 del valor futuro de la inversi\u00f3n, y al final lo multiplicamos por 12 para obtener el tasa de inter\u00e9s anual.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Cuando se utiliza RATE, cualquier dinero pagado est\u00e1 representado por un n\u00famero negativo y cualquier dinero recibido est\u00e1 representado por un n\u00famero positivo.<\/li>\n<li> Calcula la tasa de iteraci\u00f3n. No puede encontrar el resultado en 20 intentos, devuelve un tiempo de ejecuci\u00f3n de 5. <\/li>\n<\/ul>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-124\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/pm-2\/\">PMT-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ppmt\/\">PPMT-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/caballos-de-fuerza-2\/\">PV-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sln\/\">VBA SLN<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/syd\/\">VBA SYD<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA RATE figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la tasa de inter\u00e9s por per\u00edodo (con igual flujo de efectivo) para un pr\u00e9stamo o inversi\u00f3n. Sintaxis TASA(Nper, Pmt, Pv, [Fv], [Vence], [Guess]) Argumentos Nper : El n\u00famero de per\u00edodos para reembolsar el pr\u00e9stamo o la [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-548","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/omitido\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA RATE figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la tasa de inter\u00e9s por per\u00edodo (con igual flujo de efectivo) para un pr\u00e9stamo o inversi\u00f3n. Sintaxis TASA(Nper, Pmt, Pv, [Fv], [Vence], [Guess]) Argumentos Nper : El n\u00famero de per\u00edodos para reembolsar el pr\u00e9stamo o la [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/omitido\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:28:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/omitido\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/omitido\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/omitido\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/omitido\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\",\"datePublished\":\"2023-10-24T01:59:08+00:00\",\"dateModified\":\"2023-12-25T10:28:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/omitido\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/omitido\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/omitido\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/omitido\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?","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:\/\/exceladvisor.org\/es\/omitido\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?","og_description":"La funci\u00f3n VBA RATE figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la tasa de inter\u00e9s por per\u00edodo (con igual flujo de efectivo) para un pr\u00e9stamo o inversi\u00f3n. Sintaxis TASA(Nper, Pmt, Pv, [Fv], [Vence], [Guess]) Argumentos Nper : El n\u00famero de per\u00edodos para reembolsar el pr\u00e9stamo o la [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/omitido\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:28:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/omitido\/","url":"https:\/\/exceladvisor.org\/es\/omitido\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/omitido\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/omitido\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png","datePublished":"2023-10-24T01:59:08+00:00","dateModified":"2023-12-25T10:28:38+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/omitido\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/omitido\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/omitido\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/omitido\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n tasa vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=548"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/548\/revisions"}],"predecessor-version":[{"id":1332,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/548\/revisions\/1332"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}