{"id":656,"date":"2023-09-30T04:50:34","date_gmt":"2023-09-30T04:50:34","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/yo-para\/"},"modified":"2023-12-25T10:27:47","modified_gmt":"2023-12-25T10:27:47","slug":"yo-para","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/yo-para\/","title":{"rendered":"\u00bfc\u00f3mo usar if con or en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2088622569\"><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 utilizar el operador <strong>OR<\/strong> con la <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">declaraci\u00f3n IF de VBA<\/a> para probar m\u00faltiples condiciones. Cuando lo usa, le permite probar dos o m\u00e1s condiciones simult\u00e1neamente y <strong>devuelve verdadero si alguna de estas condiciones es verdadera<\/strong> . Pero si todas las condiciones son falsas solo devuelve falso en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Usando OR con IF<\/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 OR 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-57529\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-si-o-condici\u00f3n\" width=\"728\" height=\"142\"><\/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() 'two conditions to test using OR If 1 = 1 Or 2 &lt; 1 Then MsgBox \"One of the conditions is true.\" Else MsgBox \"None 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-57530\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-specifie-deux-conditions.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"581\" height=\"488\"><\/figure>\n<\/div>\n<p> Si observa el ejemplo anterior, hemos especificado dos condiciones, una si (1 = 1) y la segunda es (2 &lt; 1), y aqu\u00ed solo la primera condici\u00f3n es verdadera, e incluso si ejecut\u00f3 la l\u00ednea de c\u00f3digo que especificado 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-57531\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-la-premiere-condition-est-vraie.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"242\" height=\"192\"><\/figure>\n<\/div>\n<p> Ahora veamos si ambas condiciones son falsas, d\u00e9jame usar un c\u00f3digo diferente aqu\u00ed. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() 'two conditions to test using OR If 1 = 2 Or 2 &lt; 1 Then MsgBox \"One of the conditions is true.\" Else MsgBox \"None 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-57532\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-les-deux-conditions-sont-fausses.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"546\" height=\"475\"><\/figure>\n<\/div>\n<p> En el c\u00f3digo anterior, ambas condiciones son falsas y cuando <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">ejecuta este c\u00f3digo<\/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-57533\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-specifie-si-le-resultat-est-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"233\" height=\"172\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> M\u00faltiples condiciones con IF OR<\/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 myMacro() 'three conditions to test using OR If 1 = 1 And 2 &gt; 1 And 1 - 1 = 0 Then MsgBox \"one of the conditions is true.\" Else MsgBox \"none 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-57534\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-conditions-multiples-avec-if-ou.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"555\" height=\"472\"><\/figure>\n<\/div>\n<p> Ahora tenemos tres condiciones para probar y usamos el OR despu\u00e9s de la segunda condici\u00f3n para especificar la tercera condici\u00f3n. Como aprendiste anteriormente, cuando usas OR, una de las condiciones debe ser verdadera para que se convierta en verdadera en el resultado. 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-57535\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-specifie-pour-le-vrai-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"225\" height=\"178\"><\/figure>\n<\/div>\n<p> Y si todas las condiciones son falsas, 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 myMacro() 'three conditions to test using OR If 1 &lt; 1 And 2 &lt; 1 And 1 + 1 = 0 Then MsgBox \"one of the conditions is true.\" Else MsgBox \"none 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-57536\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-toutes-les-conditions-sont-fausses.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"247\" height=\"182\"><\/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\/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\/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 utilizar el operador OR con la declaraci\u00f3n IF de VBA para probar m\u00faltiples condiciones. Cuando lo usa, le permite probar dos o m\u00e1s condiciones simult\u00e1neamente y devuelve verdadero si alguna de estas condiciones es verdadera . Pero si todas las condiciones son falsas solo devuelve falso en el resultado. Usando OR con IF Primero, [&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-656","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 or en 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\/yo-para\/\" \/>\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 or en vba?\" \/>\n<meta property=\"og:description\" content=\"Puede utilizar el operador OR con la declaraci\u00f3n IF de VBA para probar m\u00faltiples condiciones. Cuando lo usa, le permite probar dos o m\u00e1s condiciones simult\u00e1neamente y devuelve verdadero si alguna de estas condiciones es verdadera . Pero si todas las condiciones son falsas solo devuelve falso en el resultado. Usando OR con IF Primero, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/yo-para\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.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\/yo-para\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/yo-para\/\",\"name\":\"\u00bfc\u00f3mo usar if con or en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/yo-para\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/yo-para\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\",\"datePublished\":\"2023-09-30T04:50:34+00:00\",\"dateModified\":\"2023-12-25T10:27:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/yo-para\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/yo-para\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/yo-para\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/yo-para\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo usar if con or en 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 or en 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\/yo-para\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo usar if con or en vba?","og_description":"Puede utilizar el operador OR con la declaraci\u00f3n IF de VBA para probar m\u00faltiples condiciones. Cuando lo usa, le permite probar dos o m\u00e1s condiciones simult\u00e1neamente y devuelve verdadero si alguna de estas condiciones es verdadera . Pero si todas las condiciones son falsas solo devuelve falso en el resultado. Usando OR con IF Primero, [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/yo-para\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:47+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.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\/yo-para\/","url":"https:\/\/exceladvisor.org\/es\/yo-para\/","name":"\u00bfc\u00f3mo usar if con or en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/yo-para\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/yo-para\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png","datePublished":"2023-09-30T04:50:34+00:00","dateModified":"2023-12-25T10:27:47+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/yo-para\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/yo-para\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/yo-para\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/yo-para\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo usar if con or en 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\/656","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=656"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/656\/revisions"}],"predecessor-version":[{"id":1230,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/656\/revisions\/1230"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}