{"id":1775,"date":"2014-10-05T14:35:47","date_gmt":"2014-10-05T14:35:47","guid":{"rendered":"http:\/\/excelvbatutor.com\/?p=1775"},"modified":"2018-10-03T05:14:02","modified_gmt":"2018-10-03T05:14:02","slug":"using-if-then-else-in-excel-vba-2010","status":"publish","type":"post","link":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/","title":{"rendered":"Using If&#8230;Then&#8230;Else in Excel VBA 2010"},"content":{"rendered":"<p>In Excel VBA 2010, decision making involves the use of the If..Then\u2026Else syntax to process data and display the output based on the fulfilment of certain conditions. To effectively control the VB program flow, we need to use If\u2026Then\u2026Else statement together with the conditional operators and logical operators. <\/p>\n<p><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-10-decision-making-1-if-then-else\/\">Read More&#8230;&#8230;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Excel VBA 2010, decision making involves the use of the If..Then\u2026Else syntax to process data and display the output based on the fulfilment of certain conditions. To effectively control the VB program flow, we need to use If\u2026Then\u2026Else statement together with the conditional operators and logical operators. Read More&#8230;&#8230;<\/p>\n","protected":false},"author":5012,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[6],"class_list":["post-1775","post","type-post","status-publish","format-standard","hentry","category-decison-making","tag-if-statement"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using If...Then...Else in Excel VBA 2010 - Excel VBA Tutor<\/title>\n<meta name=\"description\" content=\"This article discusses the use of If...Then...Else in Excel VBA 2010\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using If...Then...Else in Excel VBA 2010 - Excel VBA Tutor\" \/>\n<meta property=\"og:description\" content=\"This article discusses the use of If...Then...Else in Excel VBA 2010\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-05T14:35:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-03T05:14:02+00:00\" \/>\n<meta name=\"author\" content=\"Liew Voon Kiong\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liew Voon Kiong\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/\"},\"author\":{\"name\":\"Liew Voon Kiong\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"headline\":\"Using If&#8230;Then&#8230;Else in Excel VBA 2010\",\"datePublished\":\"2014-10-05T14:35:47+00:00\",\"dateModified\":\"2018-10-03T05:14:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/\"},\"wordCount\":60,\"commentCount\":0,\"keywords\":[\"If statement\"],\"articleSection\":[\"Decision making\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/\",\"name\":\"Using If...Then...Else in Excel VBA 2010 - Excel VBA Tutor\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"datePublished\":\"2014-10-05T14:35:47+00:00\",\"dateModified\":\"2018-10-03T05:14:02+00:00\",\"author\":{\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"description\":\"This article discusses the use of If...Then...Else in Excel VBA 2010\",\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using If&#8230;Then&#8230;Else in Excel VBA 2010\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelvbatutor.com\/#website\",\"url\":\"https:\/\/excelvbatutor.com\/\",\"name\":\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"description\":\"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\",\"name\":\"Liew Voon Kiong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g\",\"caption\":\"Liew Voon Kiong\"},\"url\":\"https:\/\/excelvbatutor.com\/index.php\/author\/ajs7051vba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using If...Then...Else in Excel VBA 2010 - Excel VBA Tutor","description":"This article discusses the use of If...Then...Else in Excel VBA 2010","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:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/","og_locale":"en_US","og_type":"article","og_title":"Using If...Then...Else in Excel VBA 2010 - Excel VBA Tutor","og_description":"This article discusses the use of If...Then...Else in Excel VBA 2010","og_url":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","article_published_time":"2014-10-05T14:35:47+00:00","article_modified_time":"2018-10-03T05:14:02+00:00","author":"Liew Voon Kiong","twitter_misc":{"Written by":"Liew Voon Kiong"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#article","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/"},"author":{"name":"Liew Voon Kiong","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"headline":"Using If&#8230;Then&#8230;Else in Excel VBA 2010","datePublished":"2014-10-05T14:35:47+00:00","dateModified":"2018-10-03T05:14:02+00:00","mainEntityOfPage":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/"},"wordCount":60,"commentCount":0,"keywords":["If statement"],"articleSection":["Decision making"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/","url":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/","name":"Using If...Then...Else in Excel VBA 2010 - Excel VBA Tutor","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"datePublished":"2014-10-05T14:35:47+00:00","dateModified":"2018-10-03T05:14:02+00:00","author":{"@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"description":"This article discusses the use of If...Then...Else in Excel VBA 2010","breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/10\/05\/using-if-then-else-in-excel-vba-2010\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Using If&#8230;Then&#8230;Else in Excel VBA 2010"}]},{"@type":"WebSite","@id":"https:\/\/excelvbatutor.com\/#website","url":"https:\/\/excelvbatutor.com\/","name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.","inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a","name":"Liew Voon Kiong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g","caption":"Liew Voon Kiong"},"url":"https:\/\/excelvbatutor.com\/index.php\/author\/ajs7051vba\/"}]}},"_links":{"self":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/1775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/users\/5012"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/comments?post=1775"}],"version-history":[{"count":1,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/1775\/revisions"}],"predecessor-version":[{"id":1776,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/1775\/revisions\/1776"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=1775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=1775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=1775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}