{"id":125,"date":"2015-10-24T12:15:12","date_gmt":"2015-10-24T12:15:12","guid":{"rendered":"http:\/\/99excel.com\/?p=125"},"modified":"2021-05-14T16:09:21","modified_gmt":"2021-05-14T16:09:21","slug":"conditional-statement-select-case","status":"publish","type":"post","link":"https:\/\/99excel.com\/home\/conditional-statement-select-case\/","title":{"rendered":"Conditional Statement  Select Case"},"content":{"rendered":"<p><strong>Select Case<\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>The other method of checking for single or multiple conditions is the <strong>Select Case Function<\/strong>. This is another method used for decision making based on a condition or criteria. It, in my opinion, is <strong>much better<\/strong> than If etc. This has the syntax<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"286\"><strong>Select Case<\/strong> &lt;Expression to test&gt;<\/p>\n<p><strong>Case<\/strong> <em>&lt;Test1&gt;<\/em><\/p>\n<p>Do something<\/p>\n<p><strong>Case<\/strong> <em>&lt;Test2&gt;<\/em><\/p>\n<p>Do something<\/p>\n<p><strong>Case<\/strong> Else<\/p>\n<p>Do something else<\/p>\n<p><strong>End Select<\/strong><\/td>\n<td width=\"334\"><strong>Select Case<\/strong> Range(&#8220;A1&#8221;).Value<\/p>\n<p><strong>Case <\/strong>100<\/p>\n<p>Range(&#8220;B1&#8221;).Value = 50<\/p>\n<p><strong>Case<\/strong> 200<\/p>\n<p>Range(&#8220;B1&#8221;).Value = 10<\/p>\n<p><strong>Case<\/strong> Else<\/p>\n<p>Range(&#8220;B1&#8221;).Value = 20<\/p>\n<p><strong>End Select<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Select Case \u00a0 The other method of checking for single or multiple conditions is the Select Case Function. This is another method used for decision making based on a condition or criteria. It, in my opinion, is much better than If etc. This has the syntax \u00a0 Select Case &lt;Expression to test&gt; Case &lt;Test1&gt; Do &#8230; <a title=\"Conditional Statement  Select Case\" class=\"read-more\" href=\"https:\/\/99excel.com\/home\/conditional-statement-select-case\/\" aria-label=\"More on Conditional Statement  Select Case\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-125","post","type-post","status-publish","format-standard","hentry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=125"}],"version-history":[{"count":1,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/125\/revisions"}],"predecessor-version":[{"id":894,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/125\/revisions\/894"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/categories?post=125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/tags?post=125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}