{"id":667,"date":"2023-09-29T01:34:04","date_gmt":"2023-09-29T01:34:04","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/nido-si\/"},"modified":"2023-12-25T10:28:31","modified_gmt":"2023-12-25T10:28:31","slug":"nido-si","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/nido-si\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n if anidada de vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3615329613\"><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>En VBA, puede utilizar una <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">declaraci\u00f3n IF<\/a> dentro de otra declaraci\u00f3n IF para crear IF anidados. En palabras simples, puede ejecutar una declaraci\u00f3n de prueba usando IF en funci\u00f3n del resultado de otra declaraci\u00f3n IF. En este tipo de declaraci\u00f3n condicional, es necesario probar condiciones complejas. Veamos un ejemplo: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57650\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-anidado-si\" width=\"388\" height=\"438\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, estamos probando dos condiciones, condici\u00f3n1 (1 + 1 = 2) y condici\u00f3n2 (2 + 2 = 4).<\/p>\n<p> Pero como somos la declaraci\u00f3n IF dentro de la declaraci\u00f3n IF, VBA probar\u00e1 primero la primera condici\u00f3n y luego pasar\u00e1 a la siguiente IF.<\/p>\n<p> En el segundo SI tenemos un <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">cuadro de mensaje<\/a> para mostrar si la condici\u00f3n es VERDADERA.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro1() 'first if statement If 1 + 1 = 2 Then 'second if statement If 2 + 2 = 4 Then MsgBox True End If Else MsgBox False End If End Sub<\/code><\/pre>\n<p> A continuaci\u00f3n se muestra un ejemplo del uso de varios IF en un IF. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57651\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-exemple-pour-utiliser-plusieurs-ifs-dans-un-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"562\" height=\"613\"><\/figure>\n<\/div>\n<p> Hay una diferencia entre el ejemplo que usamos anteriormente y el ejemplo anterior: en este c\u00f3digo, usamos una condici\u00f3n anidada para \u00abElse\u00bb.<\/p>\n<p> Si la primera condici\u00f3n no es verdadera, VBA saltar\u00e1 a \u00abElse\u00bb y probar\u00e1 la condici\u00f3n, y si esa condici\u00f3n no es verdadera, pasar\u00e1 a la siguiente.<\/p>\n<p> De esta manera tenemos un total de cuatro condiciones para probar.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro2() Dim myScore As Single: myScore = Range(\"A1\").Value If myScore &gt;= 80 Then MsgBox \"Excellent\" Else If myScore &gt;= 60 And myScore &lt; 80 Then MsgBox \"Good\" Else If myScore &gt;= 40 And myScore &lt; 60 Then MsgBox \"Average\" Else If myScore &lt; 40 Then MsgBox \"Poor\" End If End If End If End If End Sub<\/code><\/pre>\n<p> Esta declaraci\u00f3n IF anidada probar\u00e1 la puntuaci\u00f3n de la celda A1 y mostrar\u00e1 un cuadro de mensaje en consecuencia.<\/p>\n<h2 class=\"wp-block-heading\"> VBA anidado IF con m\u00faltiples l\u00edneas (IF)<\/h2>\n<p> Tambi\u00e9n puede utilizar dos IF diferentes para ejecutar ambos resultados (Verdadero y Falso). <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57652\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-imbrique-si-avec-plusieurs-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"638\" height=\"473\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, como puede ver, primero tenemos una condici\u00f3n para probar, y si esa condici\u00f3n es VERDADERA, entonces tiene otra condici\u00f3n para probar, y si esa segunda condici\u00f3n es VERDADERA, aparecer\u00e1 un cuadro de mensaje.<\/p>\n<p> Y si la condici\u00f3n principal es falsa, tiene otra condici\u00f3n para probar y recibir\u00e1 un cuadro de mensaje si esa condici\u00f3n es verdadera.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro3() If 1 + 1 = 2 Then If 2 - 1 = 1 Then MsgBox \"Condition1 is TRUE.\" End If Else If 3 - 2 = 1 Then MsgBox \"Condition2 is TRUE.\" End If End If End Sub<\/code><\/pre>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/salir-si\/\">VBA Salir SI<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">VBA SI (SI entonces si no)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-y\/\">VBA SI y<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/\">VBA SI NO<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/yo-para\/\">VBA SI O<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En VBA, puede utilizar una declaraci\u00f3n IF dentro de otra declaraci\u00f3n IF para crear IF anidados. En palabras simples, puede ejecutar una declaraci\u00f3n de prueba usando IF en funci\u00f3n del resultado de otra declaraci\u00f3n IF. En este tipo de declaraci\u00f3n condicional, es necesario probar condiciones complejas. Veamos un ejemplo: En el ejemplo anterior, estamos probando [&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-667","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 if anidada de 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\/nido-si\/\" \/>\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 if anidada de vba?\" \/>\n<meta property=\"og:description\" content=\"En VBA, puede utilizar una declaraci\u00f3n IF dentro de otra declaraci\u00f3n IF para crear IF anidados. En palabras simples, puede ejecutar una declaraci\u00f3n de prueba usando IF en funci\u00f3n del resultado de otra declaraci\u00f3n IF. En este tipo de declaraci\u00f3n condicional, es necesario probar condiciones complejas. Veamos un ejemplo: En el ejemplo anterior, estamos probando [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/nido-si\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:28:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.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\/nido-si\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/nido-si\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n if anidada de vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/nido-si\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/nido-si\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\",\"datePublished\":\"2023-09-29T01:34:04+00:00\",\"dateModified\":\"2023-12-25T10:28:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/nido-si\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/nido-si\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/nido-si\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/nido-si\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n if anidada de 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 if anidada de 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\/nido-si\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n if anidada de vba?","og_description":"En VBA, puede utilizar una declaraci\u00f3n IF dentro de otra declaraci\u00f3n IF para crear IF anidados. En palabras simples, puede ejecutar una declaraci\u00f3n de prueba usando IF en funci\u00f3n del resultado de otra declaraci\u00f3n IF. En este tipo de declaraci\u00f3n condicional, es necesario probar condiciones complejas. Veamos un ejemplo: En el ejemplo anterior, estamos probando [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/nido-si\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:28:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.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\/nido-si\/","url":"https:\/\/exceladvisor.org\/es\/nido-si\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n if anidada de vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/nido-si\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/nido-si\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png","datePublished":"2023-09-29T01:34:04+00:00","dateModified":"2023-12-25T10:28:31+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/nido-si\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/nido-si\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/nido-si\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/nido-si\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n if anidada de 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\/667","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=667"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/667\/revisions"}],"predecessor-version":[{"id":1318,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/667\/revisions\/1318"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}