{"id":557,"date":"2023-10-24T00:02:22","date_gmt":"2023-10-24T00:02:22","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/sln\/"},"modified":"2023-12-25T10:31:05","modified_gmt":"2023-12-25T10:31:05","slug":"sln","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/sln\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sln?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2961523616\"><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 SLN VBA figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>calcula la depreciaci\u00f3n lineal<\/strong> de un activo para un solo per\u00edodo. Obtenga m\u00e1s informaci\u00f3n sobre este c\u00e1lculo <a href=\"https:\/\/en.wikipedia.org\/wiki\/Depreciation#Straight-line_depreciation\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">aqu\u00ed<\/a> .<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>SLN (Costo, Recuperaci\u00f3n, Vida)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Costo<\/strong> : El costo inicial del activo para el cual est\u00e1 calculando la depreciaci\u00f3n.<\/li>\n<li> <strong>Salvamento<\/strong> : El valor final del activo despu\u00e9s de su vida \u00fatil.<\/li>\n<li> <strong>Vida<\/strong> : El n\u00famero de per\u00edodos durante los cuales se debe depreciar el activo.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA SLN, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-sln-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-sln-function\" width=\"838\" height=\"552\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_SLN() Range(\"A7\").Value = SLN(15000, 1200, 8) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, utilizamos SLN para calcular la depreciaci\u00f3n lineal utilizando el costo, la recuperaci\u00f3n y la vida \u00fatil y arroj\u00f3 1725 en el resultado seg\u00fan las entradas especificadas.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si la vida \u00fatil proporcionada es cero, VBA devolver\u00e1 el error de tiempo de ejecuci\u00f3n 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-88\">\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\/omitido\/\">TASA DE VBA<\/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 SLN VBA figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la depreciaci\u00f3n lineal de un activo para un solo per\u00edodo. Obtenga m\u00e1s informaci\u00f3n sobre este c\u00e1lculo aqu\u00ed . Sintaxis SLN (Costo, Recuperaci\u00f3n, Vida) Argumentos Costo : El costo inicial del activo para el cual est\u00e1 calculando [&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-557","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 vba sln?<\/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\/sln\/\" \/>\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 vba sln?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n SLN VBA figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la depreciaci\u00f3n lineal de un activo para un solo per\u00edodo. Obtenga m\u00e1s informaci\u00f3n sobre este c\u00e1lculo aqu\u00ed . Sintaxis SLN (Costo, Recuperaci\u00f3n, Vida) Argumentos Costo : El costo inicial del activo para el cual est\u00e1 calculando [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/sln\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/sln\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/sln\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sln?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/sln\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/sln\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png\",\"datePublished\":\"2023-10-24T00:02:22+00:00\",\"dateModified\":\"2023-12-25T10:31:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/sln\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/sln\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/sln\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/sln\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sln?\"}]},{\"@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 vba sln?","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\/sln\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sln?","og_description":"La funci\u00f3n SLN VBA figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la depreciaci\u00f3n lineal de un activo para un solo per\u00edodo. Obtenga m\u00e1s informaci\u00f3n sobre este c\u00e1lculo aqu\u00ed . Sintaxis SLN (Costo, Recuperaci\u00f3n, Vida) Argumentos Costo : El costo inicial del activo para el cual est\u00e1 calculando [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/sln\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/sln\/","url":"https:\/\/exceladvisor.org\/es\/sln\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sln?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/sln\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/sln\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png","datePublished":"2023-10-24T00:02:22+00:00","dateModified":"2023-12-25T10:31:05+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/sln\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/sln\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/sln\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sln.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/sln\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sln?"}]},{"@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\/557","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=557"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/557\/revisions"}],"predecessor-version":[{"id":1340,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/557\/revisions\/1340"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}