{"id":2129,"date":"2023-09-30T04:41:34","date_gmt":"2023-09-30T04:41:34","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/se-e\/"},"modified":"2023-12-10T06:26:44","modified_gmt":"2023-12-10T06:26:44","slug":"se-e","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/se-e\/","title":{"rendered":"Come utilizzare se con and in excel vba?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-4189938911\"><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>\u00c8 possibile utilizzare l&#8217;operatore <strong>AND<\/strong> con l&#8217; <a href=\"https:\/\/exceladvisor.org\/it\/se-2\/\">istruzione IF VBA<\/a> per testare pi\u00f9 condizioni e, quando lo si utilizza, consente di testare due condizioni contemporaneamente e diventare true se entrambe queste condizioni sono vere. E, se una qualsiasi delle condizioni \u00e8 falsa, restituisce falso nel risultato.<\/p><h2 class=\"wp-block-heading\"> Combina SE E<\/h2><ol type=\"1\"><li> Innanzitutto, inizia l&#8217;istruzione IF con la parola chiave &#8220;IF&#8221;.<\/li><li> Successivamente, specifica la prima condizione che desideri testare.<\/li><li> Quindi utilizzare la parola chiave AND per specificare la seconda condizione<\/li><li> Alla fine, specifica la seconda condizione che desideri testare. <\/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=\"istruzione vba-if\" width=\"819\" height=\"119\"><\/figure><\/div><p> Per capire meglio, vediamo un esempio. <\/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> Se guardi l&#8217;esempio sopra, abbiamo specificato due condizioni una se (1 = 1) e la seconda \u00e8 (2 &gt; 1) e qui entrambe le condizioni sono vere, ed \u00e8 per questo che esegue la riga di codice che abbiamo specificato se il risultato \u00e8 vero. <\/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> Ora, se una di queste due condizioni \u00e8 falsa, consentitemi di utilizzare qui un codice diverso. <\/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> Nel codice sopra, la seconda condizione \u00e8 falsa (2 &lt; 1) e quando <a href=\"https:\/\/exceladvisor.org\/it\/eseguire-una-macro-2\/\">esegui questa macro<\/a> , esegue la riga di codice che abbiamo specificato se il risultato \u00e8 falso. <\/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\"> Condizioni multiple con IF AND<\/h2><p> Allo stesso modo, puoi anche testare pi\u00f9 di due condizioni contemporaneamente. Continuiamo l&#8217;esempio sopra e aggiungiamo la terza condizione. <\/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> Ora abbiamo tre condizioni da testare e abbiamo utilizzato l&#8217;AND dopo la seconda condizione per specificare la terza condizione. Come hai appreso in precedenza, quando si utilizza AND, tutte le condizioni devono essere vere affinch\u00e9 lo diventino vere nel risultato.<\/p><p> Quando esegui questo codice, viene eseguita la riga di codice che abbiamo specificato per true. <\/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> E se una qualsiasi delle condizioni \u00e8 falsa, proprio come nel codice seguente, restituisce false. <\/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\/it\/vba\/\">Cos&#8217;\u00e8 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial correlati <\/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\/it\/esci-se\/\">VBA Esci SE<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/se-2\/\">VBA IF (SE poi altrimenti)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/altrimenti\/\">VBA SE NO<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/io-per\/\">VBA SE O<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/nido-se\/\">VBA nidificato 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-2129","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>Come utilizzare SE con AND in Excel VBA? Esercitazione 2023)<\/title>\n<meta name=\"description\" content=\"Puoi utilizzare l&#039;operatore AND con l&#039;istruzione IF VBA per testare pi\u00f9 condizioni e, quando lo usi, te lo consente\" \/>\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\/it\/se-e\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come utilizzare SE con AND in Excel VBA? Esercitazione 2023)\" \/>\n<meta property=\"og:description\" content=\"Puoi utilizzare l&#039;operatore AND con l&#039;istruzione IF VBA per testare pi\u00f9 condizioni e, quando lo usi, te lo consente\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/se-e\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:26:44+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=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/se-e\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/se-e\/\",\"name\":\"Come utilizzare SE con AND in Excel VBA? Esercitazione 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/se-e\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/se-e\/#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-10T06:26:44+00:00\",\"description\":\"Puoi utilizzare l&#39;operatore AND con l&#39;istruzione IF VBA per testare pi\u00f9 condizioni e, quando lo usi, te lo consente\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/se-e\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/se-e\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/se-e\/#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\/it\/se-e\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come utilizzare se con and in excel vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come utilizzare SE con AND in Excel VBA? Esercitazione 2023)","description":"Puoi utilizzare l&#39;operatore AND con l&#39;istruzione IF VBA per testare pi\u00f9 condizioni e, quando lo usi, te lo consente","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\/it\/se-e\/","og_locale":"it_IT","og_type":"article","og_title":"Come utilizzare SE con AND in Excel VBA? Esercitazione 2023)","og_description":"Puoi utilizzare l&#39;operatore AND con l&#39;istruzione IF VBA per testare pi\u00f9 condizioni e, quando lo usi, te lo consente","og_url":"https:\/\/exceladvisor.org\/it\/se-e\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:26:44+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":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/se-e\/","url":"https:\/\/exceladvisor.org\/it\/se-e\/","name":"Come utilizzare SE con AND in Excel VBA? Esercitazione 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/se-e\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/se-e\/#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-10T06:26:44+00:00","description":"Puoi utilizzare l&#39;operatore AND con l&#39;istruzione IF VBA per testare pi\u00f9 condizioni e, quando lo usi, te lo consente","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/se-e\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/se-e\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/se-e\/#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\/it\/se-e\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come utilizzare se con and in excel vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=2129"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2129\/revisions"}],"predecessor-version":[{"id":2830,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2129\/revisions\/2830"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=2129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}