{"id":536,"date":"2023-10-24T22:08:56","date_gmt":"2023-10-24T22:08:56","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/syd\/"},"modified":"2023-12-25T10:31:13","modified_gmt":"2023-12-25T10:31:13","slug":"syd","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/syd\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba syd?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2579176880\"><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 SYD figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>calcula la suma de a\u00f1os de depreciaci\u00f3n en n\u00fameros durante un per\u00edodo de tiempo espec\u00edfico en la vida de un activo<\/strong> .<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>SYD (costo, recuperaci\u00f3n, vida, per\u00edodo)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Costo<\/strong> : El costo inicial del activo.<\/li>\n<li> <strong>Salvamento<\/strong> : El valor del activo al finalizar.<\/li>\n<li> <strong>Vida<\/strong> : El n\u00famero de per\u00edodos durante los cuales se debe depreciar el activo.<\/li>\n<li> <strong>Per\u00edodo<\/strong> : El per\u00edodo para el cual desea calcular la depreciaci\u00f3n.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA SYD, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" title=\"ejemplo-vba-syd-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.png\" sizes=\"\" srcset=\"\" alt=\"example-vba-syd-function\"><\/figure>\n<p> En el c\u00f3digo anterior, utilizamos SYD para calcular el <a style=\"outline: none;\" href=\"https:\/\/en.wikipedia.org\/wiki\/Depreciation#Sum-of-years-digits_method\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">m\u00e9todo de suma de d\u00edgitos-a\u00f1os<\/a> para el primer a\u00f1o de los 5 a\u00f1os de vida del activo y arroj\u00f3 29333 en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si el valor de recuperaci\u00f3n es &lt; 0, la vida \u00fatil o el per\u00edodo \u2264 0, o el per\u00edodo &gt; la vida \u00fatil, VBA devolver\u00e1 un 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-56\">\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\/sln\/\">VBA SLN<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA SYD figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la suma de a\u00f1os de depreciaci\u00f3n en n\u00fameros durante un per\u00edodo de tiempo espec\u00edfico en la vida de un activo . Sintaxis SYD (costo, recuperaci\u00f3n, vida, per\u00edodo) Argumentos Costo : El costo inicial del activo. Salvamento [&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-536","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 syd?<\/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\/syd\/\" \/>\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 syd?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA SYD figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la suma de a\u00f1os de depreciaci\u00f3n en n\u00fameros durante un per\u00edodo de tiempo espec\u00edfico en la vida de un activo . Sintaxis SYD (costo, recuperaci\u00f3n, vida, per\u00edodo) Argumentos Costo : El costo inicial del activo. Salvamento [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/syd\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.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\/syd\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/syd\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba syd?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/syd\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/syd\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.png\",\"datePublished\":\"2023-10-24T22:08:56+00:00\",\"dateModified\":\"2023-12-25T10:31:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/syd\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/syd\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/syd\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/syd\/#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 syd?\"}]},{\"@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 syd?","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\/syd\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba syd?","og_description":"La funci\u00f3n VBA SYD figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la suma de a\u00f1os de depreciaci\u00f3n en n\u00fameros durante un per\u00edodo de tiempo espec\u00edfico en la vida de un activo . Sintaxis SYD (costo, recuperaci\u00f3n, vida, per\u00edodo) Argumentos Costo : El costo inicial del activo. Salvamento [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/syd\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.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\/syd\/","url":"https:\/\/exceladvisor.org\/es\/syd\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba syd?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/syd\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/syd\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.png","datePublished":"2023-10-24T22:08:56+00:00","dateModified":"2023-12-25T10:31:13+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/syd\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/syd\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/syd\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-syd.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/syd\/#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 syd?"}]},{"@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\/536","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=536"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/536\/revisions"}],"predecessor-version":[{"id":1348,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/536\/revisions\/1348"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}