{"id":11148,"date":"2022-08-01T19:27:21","date_gmt":"2022-08-01T19:27:21","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=11148"},"modified":"2024-03-29T14:12:04","modified_gmt":"2024-03-29T14:12:04","slug":"produce-multiple-outputs-in-an-if-statement","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/","title":{"rendered":"Produce Multiple Outputs in an IF Statement in Excel"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-469cdc5f-f228-4d22-841b-dd5bb9edef64\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Produce-Multiple-Outputs-in-an-IF-Statement.xlsx\">Produce-Multiple-Outputs-in-an-IF-Statement<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Produce-Multiple-Outputs-in-an-IF-Statement.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-469cdc5f-f228-4d22-841b-dd5bb9edef64\">Download File<\/a><\/div>\n\n\n\n<p>The Excel <strong>IF<\/strong> function checks whether a condition is met, and returns one value if <strong>TRUE<\/strong>, and another value if <strong>FALSE<\/strong>.<\/p>\n\n\n\n<p>The syntax of the function is:<\/p>\n\n\n\n<p><strong>IF(logical_test, [value_if_true], [value_if_false])<\/strong><\/p>\n\n\n\n<p>By default, the function has only two outcomes but there are some situations when we may want multiple or more than two outcomes.<\/p>\n\n\n\n<p>We can achieve multiple outputs using the <strong>IF<\/strong> statement by nesting the <strong>IF<\/strong> functions and using the IF statement together with other Excel functions such as the AND logical function and the OR logical function.<\/p>\n\n\n\n<p>In this tutorial, we will use five examples to explain how we can produce multiple outputs in an IF statement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example 1: Use the multiple nested IF functions<\/h2>\n\n\n\n<p>In this example, we will use two datasets. The first dataset is a school\u2019s grading system.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"269\" height=\"157\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png\" alt=\"\" class=\"wp-image-11151\"\/><\/figure>\n\n\n\n<p>The second dataset is a student\u2019s scores in a certain subject. Letter grades need to be assigned to the scores according to the school\u2019s grading system.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"294\" height=\"206\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-2.png\" alt=\"\" class=\"wp-image-11152\"\/><\/figure>\n\n\n\n<p>To assign letter grades to the scores, we do the following:<\/p>\n\n\n\n<ol>\n<li>Select cell <strong>C2<\/strong> and type in the formula:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code> =IF(B2&lt;=79,\"D\",IF(B2&lt;=87,\"C\",IF(B2&lt;=93,\"B\",\"A\")))<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"204\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-3.png\" alt=\"\" class=\"wp-image-11153\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-3.png 584w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-3-300x105.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press the Enter key and double-click or drag down the fill handle to copy the formula down the column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"272\" height=\"204\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-4.png\" alt=\"\" class=\"wp-image-11154\"\/><\/figure>\n\n\n\n<p>The letter grades are assigned to the various scores.<\/p>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF(B2&lt;=79,\"D\",IF(B2&lt;=87,\"C\",IF(B2&lt;=93,\"B\",\"A\")))<\/code><\/pre>\n\n\n\n<ul>\n<li>The IF statement checks if the score in cell B2 is less than or equal to 79. If that is true it returns grade letter D and stops checking.<\/li>\n\n\n\n<li>If cell B2 has a score that is greater than 79 but equal to or less than 87, the grade letter C is returned.<\/li>\n\n\n\n<li>If cell B2 has a score that is greater than 87 but equal to or less than 93, the grade letter B is returned.<\/li>\n\n\n\n<li>If the score is greater than 93, the grade letter A is returned.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Example 2: Use the IF statement and the AND function<\/h2>\n\n\n\n<p>In this example, we use the combination of the <strong>IF<\/strong> and <strong>AND<\/strong> functions. The AND function checks whether all arguments are TRUE and returns TRUE if all the arguments are TRUE. It returns FALSE if any or all the arguments are FALSE.<\/p>\n\n\n\n<p>In this example, a candidate is only promoted if he\/she scores at least 60 on the theory and practical tests.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"161\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-5.png\" alt=\"\" class=\"wp-image-11155\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-5.png 411w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-5-300x118.png 300w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/figure>\n\n\n\n<p>To check if a candidate qualifies for promotion or not we do the following:<\/p>\n\n\n\n<ol>\n<li>Select cell <strong>D3<\/strong> and type in the formula:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF((AND(B3&gt;=60, C3&gt;=60)), \"Promoted\", \"Not Promoted\")<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"169\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/table-description-automatically-generated-with-me-2.png\" alt=\"Table\n\nDescription automatically generated with medium confidence\" class=\"wp-image-11156\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/table-description-automatically-generated-with-me-2.png 611w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/table-description-automatically-generated-with-me-2-300x83.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press the Enter key and double-click or drag down the <strong>fill handle <\/strong>to <a href=\"https:\/\/officetuts.net\/excel\/vba\/copy-formula-down-in-vba\/\">copy the formula down<\/a> the column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"407\" height=\"171\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-7.png\" alt=\"\" class=\"wp-image-11157\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-7.png 407w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-7-300x126.png 300w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/figure>\n\n\n\n<p>The formula returns <strong>Promoted <\/strong>if both conditions are true and return <strong>Not Promoted<\/strong> otherwise.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example 3: Use the IF and OR functions<\/h2>\n\n\n\n<p>In this example, we use both the <strong>IF function<\/strong> and the <strong>OR function<\/strong> to produce multiple outputs.<\/p>\n\n\n\n<p>The <strong>OR<\/strong> function is a logical function that checks whether any of the arguments are <strong>TRUE<\/strong> and returns <strong>TRUE<\/strong> or <strong>FALSE<\/strong>. Returns <strong>FALSE only if all arguments are FALSE<\/strong>.<\/p>\n\n\n\n<p>In the following dataset, we will determine if a candidate qualifies for promotion or not based on whether the candidate got a score of at least 60 in either of the tests:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"172\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-8.png\" alt=\"\" class=\"wp-image-11158\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-8.png 411w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-8-300x126.png 300w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/figure>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol>\n<li>Select cell D3 and type in the formula:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF((OR(B3&lt;=60, C3&lt;=60)), \"Promoted\", \"Not Promoted\")<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"171\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/table-description-automatically-generated-1.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-11159\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/table-description-automatically-generated-1.png 600w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/table-description-automatically-generated-1-300x86.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press the Enter key and double-click or drag down the <strong>fill handle<\/strong> to copy the formula down the column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"410\" height=\"170\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-10.png\" alt=\"\" class=\"wp-image-11160\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-10.png 410w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-10-300x124.png 300w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/figure>\n\n\n\n<p>The formula returns <strong>Promoted <\/strong>if either of the conditions is true and returns <strong>Not Promoted<\/strong> if both conditions are false.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example 4: Apply IF, OR, and AND functions<\/h2>\n\n\n\n<p>We will use the dataset we have used in the previous example to determine the promotion of candidates using the <strong>IF, OR<\/strong>, and <strong>AND<\/strong> functions.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"172\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-11.png\" alt=\"\" class=\"wp-image-11161\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-11.png 411w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-11-300x126.png 300w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/figure>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol>\n<li>Select cell <strong>D3<\/strong> and type in the formula:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF(OR(AND(B3&gt;=50, C3&gt;=60), AND(B3&gt;=40, C3&gt;=45)), \"Promoted\", \"Not promoted\")<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"763\" height=\"173\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-12.png\" alt=\"\" class=\"wp-image-11162\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-12.png 763w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-12-300x68.png 300w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press the Enter key or double-click or drag down the fill handle to copy the formula down the column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"406\" height=\"176\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-13.png\" alt=\"\" class=\"wp-image-11163\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-13.png 406w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-13-300x130.png 300w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/><\/figure>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF(OR(AND(B3&gt;=50, C3&gt;=60), AND(B3&gt;=40, C3&gt;=45)), \"Promoted\", \"Not promoted\")<\/code><\/pre>\n\n\n\n<ul>\n<li>The formula returns <strong>Promoted<\/strong> if the value in cell B3 is &gt;=50 and the value in the cell is C3&gt;=60.<\/li>\n\n\n\n<li>The formula returns <strong>Promoted<\/strong> if the value in cell B3 is &gt;=40 and values in the cell is C3&gt;=45.<\/li>\n\n\n\n<li>The formula returns <strong>Not<\/strong> <strong>Promoted<\/strong> if both of the above are not true.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Example 5: Use the IF and AVERAGE function<\/h2>\n\n\n\n<p>In this example, we will use both the IF and AVERAGE functions to determine if the performance of the student is Excellent, Good, Poor, or Satisfactory based on their average scores.<\/p>\n\n\n\n<p>We will use the following dataset to show how this is done:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"283\" height=\"177\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-14.png\" alt=\"\" class=\"wp-image-11164\"\/><\/figure>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol>\n<li>Select cell B7 and type in the formula:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF(AVERAGE(B3:B6)&gt;=95,\"Excellent\",IF(AVERAGE(B3:B6)&gt;=90,\"Good\",IF(AVERAGE(B3:B6)&gt;=70,\"Satisfactory\",\"Poor\")))<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"826\" height=\"186\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-15.png\" alt=\"\" class=\"wp-image-11165\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-15.png 826w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-15-300x68.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-15-768x173.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press the Enter key and drag the fill handle to cell D7 to copy the formula to those cells.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"310\" height=\"174\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-16.png\" alt=\"\" class=\"wp-image-11166\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-16.png 310w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-16-300x168.png 300w\" sizes=\"(max-width: 310px) 100vw, 310px\" \/><\/figure>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<ul>\n<li>The formula returns <strong>Excellent<\/strong> if the average score of the student is 95 and above.<\/li>\n\n\n\n<li>The formula returns <strong>Good<\/strong> if the average score of the student is 90 and above but less than 95.<\/li>\n\n\n\n<li>The formula returns <strong>Satisfactory<\/strong> if the average score of the student is 70 and above but less than 90.<\/li>\n\n\n\n<li>The formula returns <strong>Poor<\/strong> if the average score of the student is below 70.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>The IF function by default returns only two outcomes but there are some situations when we may want multiple or more than two outcomes.<\/p>\n\n\n\n<p>This can be achieved by using nested IF functions and using the function together with other Excel functions.<\/p>\n\n\n\n<p>In this tutorial we have looked at 5 ways we can use the IF statement to produce multiple outputs. The examples given involve the use of nested IF functions, the use of IF function together with the AND logical function, the use of IF function together with the OR logical function, the use of the combination of IF function and OR and AND functions, and the application of the IF function together with the AVERAGE function.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Excel IF function checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. The syntax&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Produce Multiple Outputs in an IF Statement in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to produce multiple outputs in an Excel IF statement using nested IF functions and logical functions like AND and OR.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Produce Multiple Outputs in an IF Statement in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to produce multiple outputs in an Excel IF statement using nested IF functions and logical functions like AND and OR.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-01T19:27:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T14:12:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Produce Multiple Outputs in an IF Statement in Excel\",\"datePublished\":\"2022-08-01T19:27:21+00:00\",\"dateModified\":\"2024-03-29T14:12:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/\"},\"wordCount\":962,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/\",\"name\":\"Produce Multiple Outputs in an IF Statement in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png\",\"datePublished\":\"2022-08-01T19:27:21+00:00\",\"dateModified\":\"2024-03-29T14:12:04+00:00\",\"description\":\"Learn how to produce multiple outputs in an Excel IF statement using nested IF functions and logical functions like AND and OR.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Produce Multiple Outputs in an IF Statement in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Produce Multiple Outputs in an IF Statement in Excel","description":"Learn how to produce multiple outputs in an Excel IF statement using nested IF functions and logical functions like AND and OR.","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:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/","og_locale":"en_US","og_type":"article","og_title":"Produce Multiple Outputs in an IF Statement in Excel","og_description":"Learn how to produce multiple outputs in an Excel IF statement using nested IF functions and logical functions like AND and OR.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/","article_published_time":"2022-08-01T19:27:21+00:00","article_modified_time":"2024-03-29T14:12:04+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Produce Multiple Outputs in an IF Statement in Excel","datePublished":"2022-08-01T19:27:21+00:00","dateModified":"2024-03-29T14:12:04+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/"},"wordCount":962,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png","keywords":["file","pinterest"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/","url":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/","name":"Produce Multiple Outputs in an IF Statement in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png","datePublished":"2022-08-01T19:27:21+00:00","dateModified":"2024-03-29T14:12:04+00:00","description":"Learn how to produce multiple outputs in an Excel IF statement using nested IF functions and logical functions like AND and OR.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/08\/word-image-11148-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/produce-multiple-outputs-in-an-if-statement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Produce Multiple Outputs in an IF Statement in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11148"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=11148"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11148\/revisions"}],"predecessor-version":[{"id":15792,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11148\/revisions\/15792"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=11148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=11148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=11148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}