{"id":3622,"date":"2023-09-30T04:41:34","date_gmt":"2023-09-30T04:41:34","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/wenn-und\/"},"modified":"2023-12-03T13:04:59","modified_gmt":"2023-12-03T13:04:59","slug":"wenn-und","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/wenn-und\/","title":{"rendered":"Wie verwende ich if mit and in excel vba?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1312987245\"><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>Sie k\u00f6nnen den <strong>AND-<\/strong> Operator mit der <a href=\"https:\/\/exceladvisor.org\/de\/wenn-2\/\">VBA-IF-Anweisung<\/a> verwenden, um mehrere Bedingungen zu testen. Wenn Sie ihn verwenden, k\u00f6nnen Sie zwei Bedingungen gleichzeitig testen und \u201etrue\u201c erhalten, wenn beide Bedingungen wahr sind. Und wenn eine der Bedingungen falsch ist, wird im Ergebnis \u201efalsch\u201c zur\u00fcckgegeben.<\/p><h2 class=\"wp-block-heading\"> Kombinieren Sie WENN UND<\/h2><ol type=\"1\"><li> Beginnen Sie zun\u00e4chst die IF-Anweisung mit dem Schl\u00fcsselwort \u201eIF\u201c.<\/li><li> Geben Sie anschlie\u00dfend die erste Bedingung an, die Sie testen m\u00f6chten.<\/li><li> Verwenden Sie dann das Schl\u00fcsselwort AND, um die zweite Bedingung anzugeben<\/li><li> Geben Sie am Ende die zweite Bedingung an, die Sie testen m\u00f6chten. <\/li><\/ol><div class=\"wp-block-image\"><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=\"vba-if-Anweisung\" width=\"819\" height=\"119\"><\/figure><\/div><p> Schauen wir uns zum besseren Verst\u00e4ndnis ein Beispiel an. <\/p><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><div class=\"wp-block-image\"><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><\/div><p> Wenn Sie sich das obige Beispiel ansehen, haben wir zwei Bedingungen angegeben, eine wenn (1 = 1) und die zweite ist (2 &gt; 1), und hier sind beide Bedingungen wahr, und deshalb wird die Codezeile ausgef\u00fchrt, die wir angegeben haben, wenn Das Ergebnis stimmt. <\/p><div class=\"wp-block-image\"><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><\/div><p> Wenn nun eine dieser beiden Bedingungen falsch ist, m\u00f6chte ich hier einen anderen Code verwenden. <\/p><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><div class=\"wp-block-image\"><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><\/div><p> Im obigen Code ist die zweite Bedingung falsch (2 &lt; 1). Wenn Sie <a href=\"https:\/\/exceladvisor.org\/de\/ein-makro-ausfuhren-2\/\">dieses Makro ausf\u00fchren<\/a> , f\u00fchrt es die von uns angegebene Codezeile aus, wenn das Ergebnis falsch ist. <\/p><div class=\"wp-block-image\"><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><\/div><h2 class=\"wp-block-heading\"> Mehrere Bedingungen mit WENN UND<\/h2><p> Ebenso k\u00f6nnen Sie auch mehr als zwei Bedingungen gleichzeitig testen. Lassen Sie uns das obige Beispiel fortsetzen und die dritte Bedingung hinzuf\u00fcgen. <\/p><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><div class=\"wp-block-image\"><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><\/div><p> Wir m\u00fcssen jetzt drei Bedingungen testen und haben das UND nach der zweiten Bedingung verwendet, um die dritte Bedingung anzugeben. Wie Sie oben erfahren haben, m\u00fcssen bei der Verwendung von AND alle Bedingungen wahr sein, damit sie im Ergebnis wahr werden.<\/p><p> Wenn Sie diesen Code ausf\u00fchren, wird die Codezeile ausgef\u00fchrt, die wir f\u00fcr true angegeben haben. <\/p><div class=\"wp-block-image\"><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><\/div><p> Und wenn eine der Bedingungen falsch ist, wird genau wie im folgenden Code \u201efalse\u201c zur\u00fcckgegeben. <\/p><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><div class=\"wp-block-image\"><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><\/div><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\/de\/vba\/\">Was ist VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Verwandte Tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/geh-raus-wenn\/\">VBA Exit IF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/wenn-2\/\">VBA IF (WENN dann sonst)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/ansonsten\/\">VBA WENN NR<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/ich-fur\/\">VBA WENN ODER<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/nest-wenn\/\">VBA verschachteltes IF<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-3622","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>Wie verwende ich IF mit AND in Excel VBA? Anleitung 2023)<\/title>\n<meta name=\"description\" content=\"Sie k\u00f6nnen den AND-Operator mit der VBA-IF-Anweisung verwenden, um mehrere Bedingungen zu testen, und wenn Sie ihn verwenden, ist dies m\u00f6glich\" \/>\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\/de\/wenn-und\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich IF mit AND in Excel VBA? Anleitung 2023)\" \/>\n<meta property=\"og:description\" content=\"Sie k\u00f6nnen den AND-Operator mit der VBA-IF-Anweisung verwenden, um mehrere Bedingungen zu testen, und wenn Sie ihn verwenden, ist dies m\u00f6glich\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/wenn-und\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:04:59+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=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/wenn-und\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wenn-und\/\",\"name\":\"Wie verwende ich IF mit AND in Excel VBA? Anleitung 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/wenn-und\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/wenn-und\/#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-03T13:04:59+00:00\",\"description\":\"Sie k\u00f6nnen den AND-Operator mit der VBA-IF-Anweisung verwenden, um mehrere Bedingungen zu testen, und wenn Sie ihn verwenden, ist dies m\u00f6glich\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/wenn-und\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/wenn-und\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/wenn-und\/#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\/de\/wenn-und\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich if mit and in excel vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie verwende ich IF mit AND in Excel VBA? Anleitung 2023)","description":"Sie k\u00f6nnen den AND-Operator mit der VBA-IF-Anweisung verwenden, um mehrere Bedingungen zu testen, und wenn Sie ihn verwenden, ist dies m\u00f6glich","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\/de\/wenn-und\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich IF mit AND in Excel VBA? Anleitung 2023)","og_description":"Sie k\u00f6nnen den AND-Operator mit der VBA-IF-Anweisung verwenden, um mehrere Bedingungen zu testen, und wenn Sie ihn verwenden, ist dies m\u00f6glich","og_url":"https:\/\/exceladvisor.org\/de\/wenn-und\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:04:59+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":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/wenn-und\/","url":"https:\/\/exceladvisor.org\/de\/wenn-und\/","name":"Wie verwende ich IF mit AND in Excel VBA? Anleitung 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/wenn-und\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/wenn-und\/#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-03T13:04:59+00:00","description":"Sie k\u00f6nnen den AND-Operator mit der VBA-IF-Anweisung verwenden, um mehrere Bedingungen zu testen, und wenn Sie ihn verwenden, ist dies m\u00f6glich","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/wenn-und\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/wenn-und\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/wenn-und\/#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\/de\/wenn-und\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich if mit and in excel vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3622"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3622\/revisions"}],"predecessor-version":[{"id":4367,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3622\/revisions\/4367"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}