{"id":998,"date":"2023-10-29T16:04:39","date_gmt":"2023-10-29T16:04:39","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=998"},"modified":"2023-10-29T16:17:49","modified_gmt":"2023-10-29T16:17:49","slug":"funcao-mtir-em-vba","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/","title":{"rendered":"MTIR"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"998\" class=\"elementor elementor-998\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a99f6f e-flex e-con-boxed e-con e-parent\" data-id=\"0a99f6f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45ab332 elementor-icon-list--layout-inline elementor-align-center elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"45ab332\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-home\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Home<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/blog\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-blog\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Blog<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/contato\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-contao\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Contato<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/sobre\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-laugh\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Sobre<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/pesquisar-no-site\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-search\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pesquisar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f9e9804 e-flex e-con-boxed e-con e-child\" data-id=\"f9e9804\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2dfaff3 elementor-widget elementor-widget-heading\" data-id=\"2dfaff3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fun\u00e7\u00e3o MTIR em VBA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2f51315 e-flex e-con-boxed e-con e-parent\" data-id=\"2f51315\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7f4fa0a elementor-widget elementor-widget-text-editor\" data-id=\"7f4fa0a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Descri\u00e7\u00e3o:<\/h2><p>A fun\u00e7\u00e3o <code>MTIR<\/code> em VBA \u00e9 utilizada para calcular a Taxa Interna de Retorno Modificada (MTIR) em projetos financeiros. Essa fun\u00e7\u00e3o \u00e9 especialmente \u00fatil para analisar a rentabilidade de investimentos ao levar em considera\u00e7\u00e3o reinvestimentos a taxas vari\u00e1veis ao longo do tempo.<\/p><h2>Exemplos:<\/h2><pre><code>\nSub ExemploMTIR1()\n    Dim valores As Variant\n    valores = Array(-1000, 100, 200, 300, 400) ' Fluxos de caixa\n    Dim mtir As Double\n    mtir = MTIR(valores, 0.1) ' Taxa inicial de suposi\u00e7\u00e3o\n    MsgBox \"A MTIR \u00e9: \" &amp; mtir\nEnd Sub\n    <\/code><\/pre><p>Neste exemplo, a fun\u00e7\u00e3o <code>MTIR<\/code> \u00e9 utilizada para calcular a taxa interna de retorno modificada com um conjunto de fluxos de caixa.<\/p><pre><code>\nSub ExemploMTIR2()\n    Dim valores As Variant\n    valores = Array(-1000, 100, 200, 300, 400) ' Fluxos de caixa\n    Dim mtir As Double\n    mtir = MTIR(valores, 0.2) ' Taxa inicial de suposi\u00e7\u00e3o\n    MsgBox \"A MTIR \u00e9: \" &amp; mtir\nEnd Sub\n    <\/code><\/pre><p>Neste exemplo, a fun\u00e7\u00e3o <code>MTIR<\/code> \u00e9 utilizada com uma taxa inicial de suposi\u00e7\u00e3o diferente.<\/p><p><!-- Adicione mais exemplos para MTIR se necess\u00e1rio --><\/p><h2>Palavras-Chave e Descri\u00e7\u00f5es:<\/h2><table><tbody><tr><th>Palavra-Chave<\/th><th>Descri\u00e7\u00e3o<\/th><\/tr><tr><td>MTIR<\/td><td>Fun\u00e7\u00e3o para calcular a Taxa Interna de Retorno Modificada em projetos financeiros.<\/td><\/tr><tr><td>Investimentos<\/td><td>An\u00e1lise da rentabilidade de investimentos considerando reinvestimentos a taxas vari\u00e1veis.<\/td><\/tr><tr><td>Fluxos de Caixa<\/td><td>Conjunto de valores representando os ganhos e gastos ao longo do tempo.<\/td><\/tr><\/tbody><\/table><p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-731515c e-flex e-con-boxed e-con e-parent\" data-id=\"731515c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c340885 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"c340885\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b147a58 e-flex e-con-boxed e-con e-parent\" data-id=\"b147a58\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cf166ea e-con-full e-flex e-con e-child\" data-id=\"cf166ea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a0667e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8a0667e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-curdir-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o CurDir em VBA <\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-replace-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-creative-commons-nd\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Replace em VBA - Substituir<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-formatdatetime-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-americas\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o FormatDateTime em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57117f8 e-con-full e-flex e-con e-child\" data-id=\"57117f8\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6305c7b elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6305c7b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-comand-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-africa\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Comand em VBA - Comando<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-hora-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-wpforms\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Hora VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-error-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-hand-point-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Error em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b178054 e-flex e-con-boxed e-con e-parent\" data-id=\"b178054\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b2791f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3b2791f\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Home Blog Contato Sobre Pesquisar Fun\u00e7\u00e3o MTIR em VBA Descri\u00e7\u00e3o: A fun\u00e7\u00e3o MTIR em VBA \u00e9 utilizada para calcular a Taxa Interna de Retorno Modificada (MTIR) em projetos financeiros. Essa fun\u00e7\u00e3o \u00e9 especialmente \u00fatil para analisar a rentabilidade de investimentos ao levar em considera\u00e7\u00e3o reinvestimentos a taxas vari\u00e1veis ao longo do tempo. Exemplos: Sub ExemploMTIR1() &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">MTIR<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tpgb_global_settings":"","footnotes":""},"categories":[5],"tags":[75,77,27,78,30,31,32,34,35,36,38,39,40,41,79,42,43,44,46,37,29,47,48,49,50,51,52,53,54,55,80,56,58,60,61,62,63,64,65,66,67,68,69,70,81,71,86,87,82,73,72,83,84,85,57,74,28,7,11],"class_list":["post-998","post","type-post","status-publish","format-standard","hentry","category-funcoes","tag-abs","tag-atn","tag-conversao-de-texto-para-numero","tag-cos","tag-curdir","tag-data","tag-dateadd","tag-datediff","tag-datepart","tag-dateserial","tag-day","tag-doevents","tag-eof","tag-error","tag-exp","tag-fileattr","tag-filedatetime","tag-filelen","tag-freefile","tag-funcao-day","tag-funcao-val","tag-getattr","tag-getobject","tag-getsetting","tag-hora","tag-iif","tag-input","tag-inputbox","tag-instr","tag-instrrev","tag-int","tag-ipmt","tag-isarray","tag-isdate","tag-isempty","tag-ismissing","tag-isnull","tag-isobject","tag-join","tag-lbound","tag-lcase","tag-left","tag-loc","tag-lof","tag-log","tag-ltrim","tag-mid","tag-minute","tag-rnd","tag-rtrim","tag-rtrim-e-trim","tag-sgn","tag-sqr","tag-tan","tag-tir","tag-trim","tag-val","tag-vba","tag-visual-basic-for-applications"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MTIR - Saibam<\/title>\n<meta name=\"description\" content=\"A fun\u00e7\u00e3o MTIR em VBA \u00e9 uma ferramenta valiosa para analisar a rentabilidade de investimentos em projetos financeiros complexos. Ela calcula a Taxa Interna de Retorno Modificada, levando em conta reinvestimentos a taxas vari\u00e1veis. Com a MTIR, os profissionais financeiros podem obter uma vis\u00e3o mais precisa e abrangente da performance de investimentos ao longo do tempo, possibilitando decis\u00f5es mais informadas. Essa fun\u00e7\u00e3o \u00e9 essencial para avalia\u00e7\u00f5es detalhadas em \u00e1reas como finan\u00e7as corporativas, planejamento de investimentos e gest\u00e3o de portf\u00f3lio. Ao dominar a fun\u00e7\u00e3o MTIR em VBA, os analistas financeiros t\u00eam uma ferramenta poderosa para maximizar a efici\u00eancia e a precis\u00e3o de suas an\u00e1lises de investimento.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MTIR - Saibam\" \/>\n<meta property=\"og:description\" content=\"A fun\u00e7\u00e3o MTIR em VBA \u00e9 uma ferramenta valiosa para analisar a rentabilidade de investimentos em projetos financeiros complexos. Ela calcula a Taxa Interna de Retorno Modificada, levando em conta reinvestimentos a taxas vari\u00e1veis. Com a MTIR, os profissionais financeiros podem obter uma vis\u00e3o mais precisa e abrangente da performance de investimentos ao longo do tempo, possibilitando decis\u00f5es mais informadas. Essa fun\u00e7\u00e3o \u00e9 essencial para avalia\u00e7\u00f5es detalhadas em \u00e1reas como finan\u00e7as corporativas, planejamento de investimentos e gest\u00e3o de portf\u00f3lio. Ao dominar a fun\u00e7\u00e3o MTIR em VBA, os analistas financeiros t\u00eam uma ferramenta poderosa para maximizar a efici\u00eancia e a precis\u00e3o de suas an\u00e1lises de investimento.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-29T16:04:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-29T16:17:49+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/\",\"name\":\"MTIR - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"datePublished\":\"2023-10-29T16:04:39+00:00\",\"dateModified\":\"2023-10-29T16:17:49+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"A fun\u00e7\u00e3o MTIR em VBA \u00e9 uma ferramenta valiosa para analisar a rentabilidade de investimentos em projetos financeiros complexos. Ela calcula a Taxa Interna de Retorno Modificada, levando em conta reinvestimentos a taxas vari\u00e1veis. Com a MTIR, os profissionais financeiros podem obter uma vis\u00e3o mais precisa e abrangente da performance de investimentos ao longo do tempo, possibilitando decis\u00f5es mais informadas. Essa fun\u00e7\u00e3o \u00e9 essencial para avalia\u00e7\u00f5es detalhadas em \u00e1reas como finan\u00e7as corporativas, planejamento de investimentos e gest\u00e3o de portf\u00f3lio. Ao dominar a fun\u00e7\u00e3o MTIR em VBA, os analistas financeiros t\u00eam uma ferramenta poderosa para maximizar a efici\u00eancia e a precis\u00e3o de suas an\u00e1lises de investimento.\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MTIR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\",\"url\":\"https:\/\/saibam.com.br\/excel\/\",\"name\":\"Saibam\",\"description\":\"Excel Macros VBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saibam.com.br\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/saibam.com.br\/excel\"],\"url\":\"https:\/\/saibam.com.br\/excel\/author\/admin-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MTIR - Saibam","description":"A fun\u00e7\u00e3o MTIR em VBA \u00e9 uma ferramenta valiosa para analisar a rentabilidade de investimentos em projetos financeiros complexos. Ela calcula a Taxa Interna de Retorno Modificada, levando em conta reinvestimentos a taxas vari\u00e1veis. Com a MTIR, os profissionais financeiros podem obter uma vis\u00e3o mais precisa e abrangente da performance de investimentos ao longo do tempo, possibilitando decis\u00f5es mais informadas. Essa fun\u00e7\u00e3o \u00e9 essencial para avalia\u00e7\u00f5es detalhadas em \u00e1reas como finan\u00e7as corporativas, planejamento de investimentos e gest\u00e3o de portf\u00f3lio. Ao dominar a fun\u00e7\u00e3o MTIR em VBA, os analistas financeiros t\u00eam uma ferramenta poderosa para maximizar a efici\u00eancia e a precis\u00e3o de suas an\u00e1lises de investimento.","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:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/","og_locale":"pt_PT","og_type":"article","og_title":"MTIR - Saibam","og_description":"A fun\u00e7\u00e3o MTIR em VBA \u00e9 uma ferramenta valiosa para analisar a rentabilidade de investimentos em projetos financeiros complexos. Ela calcula a Taxa Interna de Retorno Modificada, levando em conta reinvestimentos a taxas vari\u00e1veis. Com a MTIR, os profissionais financeiros podem obter uma vis\u00e3o mais precisa e abrangente da performance de investimentos ao longo do tempo, possibilitando decis\u00f5es mais informadas. Essa fun\u00e7\u00e3o \u00e9 essencial para avalia\u00e7\u00f5es detalhadas em \u00e1reas como finan\u00e7as corporativas, planejamento de investimentos e gest\u00e3o de portf\u00f3lio. Ao dominar a fun\u00e7\u00e3o MTIR em VBA, os analistas financeiros t\u00eam uma ferramenta poderosa para maximizar a efici\u00eancia e a precis\u00e3o de suas an\u00e1lises de investimento.","og_url":"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/","og_site_name":"Saibam","article_published_time":"2023-10-29T16:04:39+00:00","article_modified_time":"2023-10-29T16:17:49+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/","url":"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/","name":"MTIR - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"datePublished":"2023-10-29T16:04:39+00:00","dateModified":"2023-10-29T16:17:49+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"A fun\u00e7\u00e3o MTIR em VBA \u00e9 uma ferramenta valiosa para analisar a rentabilidade de investimentos em projetos financeiros complexos. Ela calcula a Taxa Interna de Retorno Modificada, levando em conta reinvestimentos a taxas vari\u00e1veis. Com a MTIR, os profissionais financeiros podem obter uma vis\u00e3o mais precisa e abrangente da performance de investimentos ao longo do tempo, possibilitando decis\u00f5es mais informadas. Essa fun\u00e7\u00e3o \u00e9 essencial para avalia\u00e7\u00f5es detalhadas em \u00e1reas como finan\u00e7as corporativas, planejamento de investimentos e gest\u00e3o de portf\u00f3lio. Ao dominar a fun\u00e7\u00e3o MTIR em VBA, os analistas financeiros t\u00eam uma ferramenta poderosa para maximizar a efici\u00eancia e a precis\u00e3o de suas an\u00e1lises de investimento.","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/funcao-mtir-em-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"MTIR"}]},{"@type":"WebSite","@id":"https:\/\/saibam.com.br\/excel\/#website","url":"https:\/\/saibam.com.br\/excel\/","name":"Saibam","description":"Excel Macros VBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saibam.com.br\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712","name":"admin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/saibam.com.br\/excel"],"url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/"}]}},"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"Outubro 29, 2023","get_modified_date":"Outubro 29, 2023","category_list":{"category":[{"term_id":5,"name":"Fun\u00e7\u00f5es","slug":"funcoes","term_group":0,"term_taxonomy_id":5,"taxonomy":"category","description":"","parent":0,"count":59,"filter":"raw"}],"post_tag":[{"term_id":75,"name":"Abs","slug":"abs","term_group":0,"term_taxonomy_id":75,"taxonomy":"post_tag","description":"","parent":0,"count":71,"filter":"raw"},{"term_id":77,"name":"Atn","slug":"atn","term_group":0,"term_taxonomy_id":77,"taxonomy":"post_tag","description":"","parent":0,"count":70,"filter":"raw"},{"term_id":27,"name":"Convers\u00e3o de Texto para N\u00famero","slug":"conversao-de-texto-para-numero","term_group":0,"term_taxonomy_id":27,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":78,"name":"Cos","slug":"cos","term_group":0,"term_taxonomy_id":78,"taxonomy":"post_tag","description":"","parent":0,"count":69,"filter":"raw"},{"term_id":30,"name":"CurDir","slug":"curdir","term_group":0,"term_taxonomy_id":30,"taxonomy":"post_tag","description":"","parent":0,"count":122,"filter":"raw"},{"term_id":31,"name":"data","slug":"data","term_group":0,"term_taxonomy_id":31,"taxonomy":"post_tag","description":"","parent":0,"count":121,"filter":"raw"},{"term_id":32,"name":"dateadd","slug":"dateadd","term_group":0,"term_taxonomy_id":32,"taxonomy":"post_tag","description":"","parent":0,"count":120,"filter":"raw"},{"term_id":34,"name":"datediff","slug":"datediff","term_group":0,"term_taxonomy_id":34,"taxonomy":"post_tag","description":"","parent":0,"count":119,"filter":"raw"},{"term_id":35,"name":"DatePart","slug":"datepart","term_group":0,"term_taxonomy_id":35,"taxonomy":"post_tag","description":"","parent":0,"count":118,"filter":"raw"},{"term_id":36,"name":"dateserial","slug":"dateserial","term_group":0,"term_taxonomy_id":36,"taxonomy":"post_tag","description":"","parent":0,"count":117,"filter":"raw"},{"term_id":38,"name":"day","slug":"day","term_group":0,"term_taxonomy_id":38,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":39,"name":"doevents","slug":"doevents","term_group":0,"term_taxonomy_id":39,"taxonomy":"post_tag","description":"","parent":0,"count":113,"filter":"raw"},{"term_id":40,"name":"EOF","slug":"eof","term_group":0,"term_taxonomy_id":40,"taxonomy":"post_tag","description":"","parent":0,"count":111,"filter":"raw"},{"term_id":41,"name":"error","slug":"error","term_group":0,"term_taxonomy_id":41,"taxonomy":"post_tag","description":"","parent":0,"count":110,"filter":"raw"},{"term_id":79,"name":"Exp","slug":"exp","term_group":0,"term_taxonomy_id":79,"taxonomy":"post_tag","description":"","parent":0,"count":68,"filter":"raw"},{"term_id":42,"name":"FileAttr","slug":"fileattr","term_group":0,"term_taxonomy_id":42,"taxonomy":"post_tag","description":"","parent":0,"count":109,"filter":"raw"},{"term_id":43,"name":"FileDateTime","slug":"filedatetime","term_group":0,"term_taxonomy_id":43,"taxonomy":"post_tag","description":"","parent":0,"count":108,"filter":"raw"},{"term_id":44,"name":"FileLen","slug":"filelen","term_group":0,"term_taxonomy_id":44,"taxonomy":"post_tag","description":"","parent":0,"count":107,"filter":"raw"},{"term_id":46,"name":"freefile","slug":"freefile","term_group":0,"term_taxonomy_id":46,"taxonomy":"post_tag","description":"","parent":0,"count":102,"filter":"raw"},{"term_id":37,"name":"fun\u00e7\u00e3o day","slug":"funcao-day","term_group":0,"term_taxonomy_id":37,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":29,"name":"Fun\u00e7\u00e3o Val","slug":"funcao-val","term_group":0,"term_taxonomy_id":29,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":47,"name":"GetAttr","slug":"getattr","term_group":0,"term_taxonomy_id":47,"taxonomy":"post_tag","description":"","parent":0,"count":99,"filter":"raw"},{"term_id":48,"name":"GetObject","slug":"getobject","term_group":0,"term_taxonomy_id":48,"taxonomy":"post_tag","description":"","parent":0,"count":98,"filter":"raw"},{"term_id":49,"name":"GetSetting","slug":"getsetting","term_group":0,"term_taxonomy_id":49,"taxonomy":"post_tag","description":"","parent":0,"count":97,"filter":"raw"},{"term_id":50,"name":"hora","slug":"hora","term_group":0,"term_taxonomy_id":50,"taxonomy":"post_tag","description":"","parent":0,"count":96,"filter":"raw"},{"term_id":51,"name":"iif","slug":"iif","term_group":0,"term_taxonomy_id":51,"taxonomy":"post_tag","description":"","parent":0,"count":95,"filter":"raw"},{"term_id":52,"name":"Input","slug":"input","term_group":0,"term_taxonomy_id":52,"taxonomy":"post_tag","description":"","parent":0,"count":94,"filter":"raw"},{"term_id":53,"name":"InputBox","slug":"inputbox","term_group":0,"term_taxonomy_id":53,"taxonomy":"post_tag","description":"","parent":0,"count":93,"filter":"raw"},{"term_id":54,"name":"InStr","slug":"instr","term_group":0,"term_taxonomy_id":54,"taxonomy":"post_tag","description":"","parent":0,"count":92,"filter":"raw"},{"term_id":55,"name":"InStrRev","slug":"instrrev","term_group":0,"term_taxonomy_id":55,"taxonomy":"post_tag","description":"","parent":0,"count":91,"filter":"raw"},{"term_id":80,"name":"Int","slug":"int","term_group":0,"term_taxonomy_id":80,"taxonomy":"post_tag","description":"","parent":0,"count":67,"filter":"raw"},{"term_id":56,"name":"IPmt","slug":"ipmt","term_group":0,"term_taxonomy_id":56,"taxonomy":"post_tag","description":"","parent":0,"count":90,"filter":"raw"},{"term_id":58,"name":"IsArray","slug":"isarray","term_group":0,"term_taxonomy_id":58,"taxonomy":"post_tag","description":"","parent":0,"count":88,"filter":"raw"},{"term_id":60,"name":"IsDate","slug":"isdate","term_group":0,"term_taxonomy_id":60,"taxonomy":"post_tag","description":"","parent":0,"count":87,"filter":"raw"},{"term_id":61,"name":"IsEmpty","slug":"isempty","term_group":0,"term_taxonomy_id":61,"taxonomy":"post_tag","description":"","parent":0,"count":86,"filter":"raw"},{"term_id":62,"name":"IsMissing","slug":"ismissing","term_group":0,"term_taxonomy_id":62,"taxonomy":"post_tag","description":"","parent":0,"count":84,"filter":"raw"},{"term_id":63,"name":"IsNull","slug":"isnull","term_group":0,"term_taxonomy_id":63,"taxonomy":"post_tag","description":"","parent":0,"count":83,"filter":"raw"},{"term_id":64,"name":"IsObject","slug":"isobject","term_group":0,"term_taxonomy_id":64,"taxonomy":"post_tag","description":"","parent":0,"count":81,"filter":"raw"},{"term_id":65,"name":"Join","slug":"join","term_group":0,"term_taxonomy_id":65,"taxonomy":"post_tag","description":"","parent":0,"count":80,"filter":"raw"},{"term_id":66,"name":"LBound","slug":"lbound","term_group":0,"term_taxonomy_id":66,"taxonomy":"post_tag","description":"","parent":0,"count":79,"filter":"raw"},{"term_id":67,"name":"LCase","slug":"lcase","term_group":0,"term_taxonomy_id":67,"taxonomy":"post_tag","description":"","parent":0,"count":78,"filter":"raw"},{"term_id":68,"name":"Left","slug":"left","term_group":0,"term_taxonomy_id":68,"taxonomy":"post_tag","description":"","parent":0,"count":77,"filter":"raw"},{"term_id":69,"name":"LOC","slug":"loc","term_group":0,"term_taxonomy_id":69,"taxonomy":"post_tag","description":"","parent":0,"count":76,"filter":"raw"},{"term_id":70,"name":"LOF","slug":"lof","term_group":0,"term_taxonomy_id":70,"taxonomy":"post_tag","description":"","parent":0,"count":75,"filter":"raw"},{"term_id":81,"name":"Log","slug":"log","term_group":0,"term_taxonomy_id":81,"taxonomy":"post_tag","description":"","parent":0,"count":65,"filter":"raw"},{"term_id":71,"name":"LTrim","slug":"ltrim","term_group":0,"term_taxonomy_id":71,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":86,"name":"MID","slug":"mid","term_group":0,"term_taxonomy_id":86,"taxonomy":"post_tag","description":"","parent":0,"count":59,"filter":"raw"},{"term_id":87,"name":"Minute","slug":"minute","term_group":0,"term_taxonomy_id":87,"taxonomy":"post_tag","description":"","parent":0,"count":58,"filter":"raw"},{"term_id":82,"name":"Rnd","slug":"rnd","term_group":0,"term_taxonomy_id":82,"taxonomy":"post_tag","description":"","parent":0,"count":64,"filter":"raw"},{"term_id":73,"name":"rtrim","slug":"rtrim","term_group":0,"term_taxonomy_id":73,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":72,"name":"RTrim e Trim","slug":"rtrim-e-trim","term_group":0,"term_taxonomy_id":72,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":83,"name":"Sgn","slug":"sgn","term_group":0,"term_taxonomy_id":83,"taxonomy":"post_tag","description":"","parent":0,"count":63,"filter":"raw"},{"term_id":84,"name":"Sqr","slug":"sqr","term_group":0,"term_taxonomy_id":84,"taxonomy":"post_tag","description":"","parent":0,"count":61,"filter":"raw"},{"term_id":85,"name":"Tan","slug":"tan","term_group":0,"term_taxonomy_id":85,"taxonomy":"post_tag","description":"","parent":0,"count":60,"filter":"raw"},{"term_id":57,"name":"TIR","slug":"tir","term_group":0,"term_taxonomy_id":57,"taxonomy":"post_tag","description":"","parent":0,"count":89,"filter":"raw"},{"term_id":74,"name":"trim","slug":"trim","term_group":0,"term_taxonomy_id":74,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":28,"name":"Val","slug":"val","term_group":0,"term_taxonomy_id":28,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":7,"name":"VBA","slug":"vba","term_group":0,"term_taxonomy_id":7,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":11,"name":"Visual Basic for Applications","slug":"visual-basic-for-applications","term_group":0,"term_taxonomy_id":11,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"}],"post_format":false},"author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","author_email":"admin@saibam.com.br","author_website":"https:\/\/saibam.com.br\/excel","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"Pizza","author_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=200&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=400&#038;d=mm&#038;r=g 2x' class='avatar avatar-200 photo' height='200' width='200' decoding='async'\/>","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":{"category":"<a href=\"https:\/\/saibam.com.br\/excel\/category\/funcoes\/\" alt=\"Fun\u00e7\u00f5es\" class=\"category-funcoes\">Fun\u00e7\u00f5es<\/a> ","post_tag":"<a href=\"https:\/\/saibam.com.br\/excel\/tag\/abs\/\" alt=\"Abs\" class=\"post_tag-abs\">Abs<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/atn\/\" alt=\"Atn\" class=\"post_tag-atn\">Atn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/conversao-de-texto-para-numero\/\" alt=\"Convers\u00e3o de Texto para N\u00famero\" class=\"post_tag-conversao-de-texto-para-numero\">Convers\u00e3o de Texto para N\u00famero<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cos\/\" alt=\"Cos\" class=\"post_tag-cos\">Cos<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/curdir\/\" alt=\"CurDir\" class=\"post_tag-curdir\">CurDir<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/data\/\" alt=\"data\" class=\"post_tag-data\">data<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateadd\/\" alt=\"dateadd\" class=\"post_tag-dateadd\">dateadd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datediff\/\" alt=\"datediff\" class=\"post_tag-datediff\">datediff<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datepart\/\" alt=\"DatePart\" class=\"post_tag-datepart\">DatePart<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateserial\/\" alt=\"dateserial\" class=\"post_tag-dateserial\">dateserial<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/day\/\" alt=\"day\" class=\"post_tag-day\">day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/doevents\/\" alt=\"doevents\" class=\"post_tag-doevents\">doevents<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/eof\/\" alt=\"EOF\" class=\"post_tag-eof\">EOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/error\/\" alt=\"error\" class=\"post_tag-error\">error<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/exp\/\" alt=\"Exp\" class=\"post_tag-exp\">Exp<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/fileattr\/\" alt=\"FileAttr\" class=\"post_tag-fileattr\">FileAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filedatetime\/\" alt=\"FileDateTime\" class=\"post_tag-filedatetime\">FileDateTime<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filelen\/\" alt=\"FileLen\" class=\"post_tag-filelen\">FileLen<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/freefile\/\" alt=\"freefile\" class=\"post_tag-freefile\">freefile<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-day\/\" alt=\"fun\u00e7\u00e3o day\" class=\"post_tag-funcao-day\">fun\u00e7\u00e3o day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-val\/\" alt=\"Fun\u00e7\u00e3o Val\" class=\"post_tag-funcao-val\">Fun\u00e7\u00e3o Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getattr\/\" alt=\"GetAttr\" class=\"post_tag-getattr\">GetAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getobject\/\" alt=\"GetObject\" class=\"post_tag-getobject\">GetObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getsetting\/\" alt=\"GetSetting\" class=\"post_tag-getsetting\">GetSetting<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/hora\/\" alt=\"hora\" class=\"post_tag-hora\">hora<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/iif\/\" alt=\"iif\" class=\"post_tag-iif\">iif<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/input\/\" alt=\"Input\" class=\"post_tag-input\">Input<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/inputbox\/\" alt=\"InputBox\" class=\"post_tag-inputbox\">InputBox<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instr\/\" alt=\"InStr\" class=\"post_tag-instr\">InStr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instrrev\/\" alt=\"InStrRev\" class=\"post_tag-instrrev\">InStrRev<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/int\/\" alt=\"Int\" class=\"post_tag-int\">Int<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ipmt\/\" alt=\"IPmt\" class=\"post_tag-ipmt\">IPmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isarray\/\" alt=\"IsArray\" class=\"post_tag-isarray\">IsArray<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isdate\/\" alt=\"IsDate\" class=\"post_tag-isdate\">IsDate<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isempty\/\" alt=\"IsEmpty\" class=\"post_tag-isempty\">IsEmpty<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ismissing\/\" alt=\"IsMissing\" class=\"post_tag-ismissing\">IsMissing<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isnull\/\" alt=\"IsNull\" class=\"post_tag-isnull\">IsNull<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isobject\/\" alt=\"IsObject\" class=\"post_tag-isobject\">IsObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/join\/\" alt=\"Join\" class=\"post_tag-join\">Join<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lbound\/\" alt=\"LBound\" class=\"post_tag-lbound\">LBound<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lcase\/\" alt=\"LCase\" class=\"post_tag-lcase\">LCase<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/left\/\" alt=\"Left\" class=\"post_tag-left\">Left<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/loc\/\" alt=\"LOC\" class=\"post_tag-loc\">LOC<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lof\/\" alt=\"LOF\" class=\"post_tag-lof\">LOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/log\/\" alt=\"Log\" class=\"post_tag-log\">Log<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ltrim\/\" alt=\"LTrim\" class=\"post_tag-ltrim\">LTrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/mid\/\" alt=\"MID\" class=\"post_tag-mid\">MID<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/minute\/\" alt=\"Minute\" class=\"post_tag-minute\">Minute<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rnd\/\" alt=\"Rnd\" class=\"post_tag-rnd\">Rnd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim\/\" alt=\"rtrim\" class=\"post_tag-rtrim\">rtrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim-e-trim\/\" alt=\"RTrim e Trim\" class=\"post_tag-rtrim-e-trim\">RTrim e Trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sgn\/\" alt=\"Sgn\" class=\"post_tag-sgn\">Sgn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sqr\/\" alt=\"Sqr\" class=\"post_tag-sqr\">Sqr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tan\/\" alt=\"Tan\" class=\"post_tag-tan\">Tan<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tir\/\" alt=\"TIR\" class=\"post_tag-tir\">TIR<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/trim\/\" alt=\"trim\" class=\"post_tag-trim\">trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/val\/\" alt=\"Val\" class=\"post_tag-val\">Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vba\/\" alt=\"VBA\" class=\"post_tag-vba\">VBA<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/visual-basic-for-applications\/\" alt=\"Visual Basic for Applications\" class=\"post_tag-visual-basic-for-applications\">Visual Basic for Applications<\/a> "},"_links":{"self":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/comments?post=998"}],"version-history":[{"count":5,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/998\/revisions"}],"predecessor-version":[{"id":1018,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/998\/revisions\/1018"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}