{"id":657,"date":"2023-09-30T04:41:34","date_gmt":"2023-09-30T04:41:34","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/si-y\/"},"modified":"2023-12-25T10:27:46","modified_gmt":"2023-12-25T10:27:46","slug":"si-y","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/si-y\/","title":{"rendered":"\u00bfc\u00f3mo usar if con and en excel vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1122637282\"><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>Puede usar el operador <strong>AND<\/strong> con la <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">declaraci\u00f3n IF de VBA<\/a> para probar m\u00faltiples condiciones y, cuando lo usa, le permite probar dos condiciones simult\u00e1neamente y ser verdadera si ambas condiciones son verdaderas. Y, si alguna de las condiciones es falsa, devuelve falsa en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Combinar SI Y<\/h2>\n<ol type=\"1\">\n<li> Primero, comience la declaraci\u00f3n IF con la palabra clave \u00abIF\u00bb.<\/li>\n<li> Despu\u00e9s de eso, especifique la primera condici\u00f3n que desea probar.<\/li>\n<li> Luego use la palabra clave AND para especificar la segunda condici\u00f3n.<\/li>\n<li> Al final, especifique la segunda condici\u00f3n que desea probar. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57514\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\" sizes=\"auto, \" srcset=\"\" alt=\"declaraci\u00f3n vba-if\" width=\"819\" height=\"119\"><\/figure>\n<\/div>\n<p> Para comprenderlo mejor, veamos un ejemplo. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() If 1 = 1 And 2 &gt; 1 Then MsgBox \"Both of the conditions are true.\" Else MsgBox \"Maybe one or both of the conditions are true.\" End If End Sub<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-vba-si-exemple-dinstruction.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"678\" height=\"351\"><\/figure>\n<\/div>\n<p> Si observa el ejemplo anterior, hemos especificado dos condiciones, una si (1 = 1) y la segunda es (2 &gt; 1) y aqu\u00ed ambas condiciones son verdaderas, y es por eso que ejecuta la l\u00ednea de c\u00f3digo que especificamos si el resultado es verdadero. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57516\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-execute-la-ligne-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"232\" height=\"173\"><\/figure>\n<\/div>\n<p> Ahora, si alguna de estas dos condiciones es falsa, perm\u00edtanme usar un c\u00f3digo diferente aqu\u00ed. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro1() If 1 = 1 And 2 &lt; 1 Then MsgBox \"Both of the conditions are true.\" Else MsgBox \"Maybe one or both of the conditions are true.\" End If End Sub<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57517\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-deuxieme-condition-est-fausse.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"655\" height=\"351\"><\/figure>\n<\/div>\n<p> En el c\u00f3digo anterior, la segunda condici\u00f3n es falsa (2 &lt;1) y cuando <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">ejecuta esta macro<\/a> , ejecuta la l\u00ednea de c\u00f3digo que especificamos si el resultado es falso. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57518\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-le-resultat-est-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"352\" height=\"192\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> M\u00faltiples condiciones con IF AND<\/h2>\n<p> Del mismo modo, tambi\u00e9n puedes probar m\u00e1s de dos condiciones al mismo tiempo. Continuemos con el ejemplo anterior y agreguemosle la tercera condici\u00f3n. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro2() If 1 = 1 And 2 &gt; 1 And 1 - 1 = 0 Then MsgBox \"All the conditions are true.\" Else MsgBox \"Some conditions are false.\" End If End Sub<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57519\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-conditions-multiples-avec-if-et.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"521\" height=\"374\"><\/figure>\n<\/div>\n<p> Ahora tenemos tres condiciones para probar y usamos AND despu\u00e9s de la segunda condici\u00f3n para especificar la tercera condici\u00f3n. Como aprendiste anteriormente, al usar AND, todas las condiciones deben ser verdaderas para que se conviertan en verdaderas en el resultado.<\/p>\n<p> Cuando ejecuta este c\u00f3digo, ejecuta la l\u00ednea de c\u00f3digo que especificamos como verdadero. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-specifie-pour-le-vrai.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"211\" height=\"178\"><\/figure>\n<\/div>\n<p> Y si alguna de las condiciones es falsa, tal como lo hizo en el siguiente c\u00f3digo, devuelve falso. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro3() If 1 = 1 And 2 &lt; 1 And 1 + 1 = 0 Then MsgBox \"All the conditions are true.\" Else MsgBox \"Some conditions are false.\" End If End Sub<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57521\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-condition-est-fausse.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"221\" height=\"188\"><\/figure>\n<\/div>\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\/de-lo-contrario\/\">VBA SI NO<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/yo-para\/\">VBA SI O<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/nido-si\/\">VBA anidado SI<\/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>Puede usar el operador AND con la declaraci\u00f3n IF de VBA para probar m\u00faltiples condiciones y, cuando lo usa, le permite probar dos condiciones simult\u00e1neamente y ser verdadera si ambas condiciones son verdaderas. Y, si alguna de las condiciones es falsa, devuelve falsa en el resultado. Combinar SI Y Primero, comience la declaraci\u00f3n IF con [&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-657","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 usar if con and en excel 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\/si-y\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo usar if con and en excel vba?\" \/>\n<meta property=\"og:description\" content=\"Puede usar el operador AND con la declaraci\u00f3n IF de VBA para probar m\u00faltiples condiciones y, cuando lo usa, le permite probar dos condiciones simult\u00e1neamente y ser verdadera si ambas condiciones son verdaderas. Y, si alguna de las condiciones es falsa, devuelve falsa en el resultado. Combinar SI Y Primero, comience la declaraci\u00f3n IF con [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/si-y\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.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\/si-y\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/si-y\/\",\"name\":\"\u00bfc\u00f3mo usar if con and en excel vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/si-y\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/si-y\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\",\"datePublished\":\"2023-09-30T04:41:34+00:00\",\"dateModified\":\"2023-12-25T10:27:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/si-y\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/si-y\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/si-y\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/si-y\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo usar if con and en excel 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 usar if con and en excel 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\/si-y\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo usar if con and en excel vba?","og_description":"Puede usar el operador AND con la declaraci\u00f3n IF de VBA para probar m\u00faltiples condiciones y, cuando lo usa, le permite probar dos condiciones simult\u00e1neamente y ser verdadera si ambas condiciones son verdaderas. Y, si alguna de las condiciones es falsa, devuelve falsa en el resultado. Combinar SI Y Primero, comience la declaraci\u00f3n IF con [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/si-y\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.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\/si-y\/","url":"https:\/\/exceladvisor.org\/es\/si-y\/","name":"\u00bfc\u00f3mo usar if con and en excel vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/si-y\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/si-y\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png","datePublished":"2023-09-30T04:41:34+00:00","dateModified":"2023-12-25T10:27:46+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/si-y\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/si-y\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/si-y\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/si-y\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo usar if con and en excel 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\/657","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=657"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/657\/revisions"}],"predecessor-version":[{"id":1228,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/657\/revisions\/1228"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}