{"id":12136,"date":"2012-04-24T07:16:08","date_gmt":"2012-04-24T07:16:08","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1605"},"modified":"2022-08-12T11:15:27","modified_gmt":"2022-08-12T11:15:27","slug":"vba-programming-if-then-statement","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/","title":{"rendered":"VBA Programming : If Then Statement"},"content":{"rendered":"<p>This Article is going to teach you about Conditional Programming. By Conditional Programming, I mean, the execution of certain statements based on certain conditions. Sometimes in VBA programming, we want to execute certain statements only when a specific condition is met. <strong>If Then Statement<\/strong> helps you achieving this.<\/p>\n<p>\nNow we will discuss about all aspects of <strong>If Then<\/strong> Statements. We can use If Then statements in many ways.<\/p>\n<h1>If Then Statement <\/h1>\n<p><div id=\"attachment_242506\" style=\"width: 303px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-242506\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_Then-1.png\" alt=\"If Then Statement - VBA\" width=\"293\" height=\"377\" class=\"size-full wp-image-242506\" srcset=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_Then-1.png 293w, https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_Then-1-249x320.png 249w, https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_Then-1-117x150.png 117w\" sizes=\"(max-width: 293px) 100vw, 293px\" \/><p id=\"caption-attachment-242506\" class=\"wp-caption-text\">If Then Statement &#8211; VBA<\/p><\/div><br \/>\n<br \/>\nAs the above image illustrates, a set of conditions will be checked and If that is True, then a Set of statements will be executed otherwise it will not be executed.<\/p>\n<h3>Syntax:<\/h3>\n<p><strong>If <\/strong><i>Condition<\/i> <strong>Then<\/strong><br \/>\n<i><br \/>\nStatement 1&#8230;.<br \/>\nStatement 2&#8230;.<br \/>\n&#8230;.<br \/>\n&#8230;.<\/i><strong> End If<\/strong><\/p>\n<p><\/p>\n<h3>Example:<\/h3>\n<p><\/p>\n<pre><code class=\"language-vbnet\">\r\nPrivate Sub CommandButton1_Click()\r\n\tDim Score As Integer\r\n\tScore = InputBox(\"Enter your Score\", \"Enter Score\")\r\n\tIf Score >= 45 Then\r\n\t\tMsgBox (\"You are Passed\")\r\n\tEnd If\r\nEnd Sub\r\n<\/code><\/pre>\n<h4>Explanation of the Above Code:<\/h4>\n<p>1. On Clicking on the Command Button, You will be asked to provide the Score in Input Box.<br \/>\n2. Score will be Compared <i> if it is Greater than or Equal to 45 (>=45)<\/i><br \/>\n3. If the above condition is true( if you have entered some greater number than 45) then a Message will be displayed as <strong>You are passed<\/strong><br \/>\n4. If you have entered less than 45, then the condition will fail and in that case No message will be displayed.<\/p>\n<p>\nFrom the above example, It is clear that, if the condition is True then the message is Displayed. If it is False then nothing is happening.<br \/>\nSometimes, we are in a situation, where we want to execute certain Statements, if the condition is True and a set of Different Statements, when it is False. To achieve this, we use <strong>If Else <\/strong> Statement.\n<\/p>\n<h1>If else Statement: <\/h1>\n<div id=\"attachment_242508\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-242508\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png\" alt=\"If else Statement - VBA\" width=\"670\" height=\"383\" class=\"size-full wp-image-242508\" srcset=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png 670w, https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1-480x274.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 670px, 100vw\" \/><p id=\"caption-attachment-242508\" class=\"wp-caption-text\">If else Statement &#8211; VBA<\/p><\/div>\n<p>As the above image illustrates, a set of condition will be checked and If that is True, then a Set of statements will be executed and if Condition is False then a different set of Statements will be executed.<\/p>\n<h2>Syntax:<\/h2>\n<p><strong>If <\/strong><i>Condition<\/i> <strong>Then<\/strong><br \/>\n<i><br \/>\nStatement 1&#8230;.<br \/>\nStatement 2&#8230;.<br \/>\n&#8230;.<br \/>\n&#8230;.<\/i><strong>Else<\/strong><br \/>\n<i>Statement 1&#8230;.<br \/>\nStatement 2&#8230;.<br \/>\n&#8230;.<br \/>\n&#8230;.<\/i><br \/>\n<strong> End If<\/strong><\/p>\n<h2>Example:<\/h2>\n<pre><code class=\"language-vbnet\">\r\nPrivate Sub CommandButton1_Click()\r\n\tDim Score As Integer\r\n\tScore = InputBox(\"Enter your Score\", \"Enter Score\")\r\n\tIf Score >= 45 Then\r\n\t\tMsgBox (\"You are Passed\")\r\n\tElse\r\n\t\tMsgBox (\"You are Failed\")\r\n\tEnd If\r\nEnd Sub\r\n<\/code><\/pre>\n<h4>Explanation of the Above Code:<\/h4>\n<p>1. On Clicking on the Command Button, You will be asked to provide the Score in Input Box.<br \/>\n2. Score will be Compared <i> if it is Greater than or Equal to 45 (>=45)<\/i><br \/>\n3. If the above condition is true( if you have entered some greater number than 45) then a Message will be displayed as <strong>You are passed<\/strong><br \/>\n4. If you have entered less than 45, then the condition will fail and in that case the message which is there in <strong> Else<\/strong> part will be displayed.<strong> You are Failed<\/strong><\/p>\n<h1>Nested If Else Condition (Multiple If else Statement)<\/h1>\n<p>You can use multiple If Else statements within If else statements. This is called <strong>Nested If else<\/strong> or <strong>Multiple If else Conditions<\/strong> Refer the below example:<\/p>\n<pre><code class=\"language-vbnet\">\r\nPrivate Sub CommandButton1_Click()\r\n\tDim Score As Integer\r\n\tScore = InputBox(\"Enter your Score\", \"Enter Score\")\r\n\tIf Score >= 45 Then\r\n\t\tIf Score >= 60 Then\r\n\t\t\tMsgBox (\"You are Passed in First Division\")\r\n\t\tElse\r\n\t\t\tMsgBox (\"You are Passed\")\r\n\t\tEnd If\r\n\tElse\r\n\t\tMsgBox (\"You are Failed\")\r\n\tEnd If\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n<p>\nIn the above example you can see, in the first If Part, there is another If else statement is executed. It means when the outer If condition is satisfied then Control will get inside and check the Condition of another If Else statement and based on that it will execute the statements.\n<\/p>\n<h3>Note:<\/h3>\n<p> In Nested If else statements, Control goes to Inner If Else, only when outer If Else is satisfied, otherwise it will ignore the inner If else, even though the condition is satisfied.<\/p>\n<p>\nIt is not a good Idea to use Nesting of If Else Conditions for more than 3-4 times. It becomes very difficult to understand the code. Also it takes long time to execute all the conditions. To overcome this problem, you should use <strong>Select Case Statement<\/strong>.<\/p>\n<div class=\"alert alert-warning\">\nTo Check out more Excel Macro Tutorials, visit <strong><a href=\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\" target=\"_blank\" rel=\"noopener\">Excel Macro Tutorial<\/a><\/strong>\n<\/div>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>This Article is going to teach you about Conditional Programming. By Conditional Programming, I mean, the execution of certain statements based on certain conditions. Sometimes in VBA programming, we want to execute certain statements only when a specific condition is met. If Then Statement helps you achieving this. Now we will discuss about all aspects [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":242508,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[5204],"tags":[],"class_list":["post-12136","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vba-programming"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA Programming : If Then Statement - Let&#039;s excel in Excel<\/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:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA Programming : If Then Statement\" \/>\n<meta property=\"og:description\" content=\"This Article is going to teach you about Conditional Programming. By Conditional Programming, I mean, the execution of certain statements based on certain conditions. Sometimes in VBA programming, we want to execute certain statements only when a specific condition is met. If Then Statement helps you achieving this. Now we will discuss about all aspects [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-24T07:16:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-12T11:15:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"670\" \/>\n\t<meta property=\"og:image:height\" content=\"383\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"VBA Programming : If Then Statement\",\"datePublished\":\"2012-04-24T07:16:08+00:00\",\"dateModified\":\"2022-08-12T11:15:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/\"},\"wordCount\":597,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png\",\"articleSection\":[\"VBA Programming\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/\",\"name\":\"VBA Programming : If Then Statement - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png\",\"datePublished\":\"2012-04-24T07:16:08+00:00\",\"dateModified\":\"2022-08-12T11:15:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png\",\"width\":670,\"height\":383,\"caption\":\"If else Statement - VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA Programming\",\"item\":\"https:\/\/vmlogger.com\/excel\/vba-programming\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VBA Programming : If Then Statement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"VBA Programming : If Then Statement - Let&#039;s excel in Excel","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:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/","og_locale":"en_US","og_type":"article","og_title":"VBA Programming : If Then Statement","og_description":"This Article is going to teach you about Conditional Programming. By Conditional Programming, I mean, the execution of certain statements based on certain conditions. Sometimes in VBA programming, we want to execute certain statements only when a specific condition is met. If Then Statement helps you achieving this. Now we will discuss about all aspects [&hellip;]","og_url":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-04-24T07:16:08+00:00","article_modified_time":"2022-08-12T11:15:27+00:00","og_image":[{"width":670,"height":383,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"VBA Programming : If Then Statement","datePublished":"2012-04-24T07:16:08+00:00","dateModified":"2022-08-12T11:15:27+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/"},"wordCount":597,"commentCount":4,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png","articleSection":["VBA Programming"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/","url":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/","name":"VBA Programming : If Then Statement - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png","datePublished":"2012-04-24T07:16:08+00:00","dateModified":"2022-08-12T11:15:27+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/04\/If_else-1.png","width":670,"height":383,"caption":"If else Statement - VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/04\/vba-programming-if-then-statement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"VBA Programming","item":"https:\/\/vmlogger.com\/excel\/vba-programming\/"},{"@type":"ListItem","position":3,"name":"VBA Programming : If Then Statement"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12136"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12136"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12136\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242508"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}