<\/p>\n
This is your one stop shop on learning the new formulas<\/a> in Excel 2019: CONCAT, IFS, MAXIFS, MINIFS, SWITCH and TEXTJOIN!<\/strong><\/p>\n\n\nTable of Contents<\/p>\n<\/span><\/div>\nFree Practice Workbook<\/a><\/li>Want to Master the New Formulas in Excel 2019?<\/a><\/li>CONCAT FORMULA<\/a><\/li>IFS FORMULA<\/a><\/li>MAXIFS FORMULA<\/a><\/li>MINIFS FORMULA<\/a><\/li>SWITCH FORMULA<\/a><\/li>TEXTJOIN FORMULA<\/a><\/li><\/ul><\/nav><\/div>\n<\/span>Want to Master the New Formulas in Excel 2019?<\/strong><\/em><\/span><\/h2>\n*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/8cCCRqT835Q\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up ??<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"CONCAT_FORMULA\"><\/span>CONCAT FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Concatenates a list together without a delimiter<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=CONCAT(<span style=\"color: #0000ff;\">text1<\/span>, <span style=\"color: #ff6600;\">[text2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=CONCAT(<span style=\"color: #0000ff;\">first text to combine<\/span>, <span style=\"color: #ff6600;\">[second text to combine], …<\/span>)<\/p>\n<hr \/>\n<p>Do you want to combine text or a range of cells together easily? The\u00a0<strong>CONCAT Formula\u00a0<\/strong>in Excel will do this for you in a flash! The\u00a0<strong>CONCAT Formula\u00a0<\/strong>was introduced in Excel 2019.<\/p>\n<p>It will simply combine the text you specify together into a single text.<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0ec59hlQkvw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">CONCAT-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<h3><\/h3>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>CONCAT\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=CONCAT(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10353\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01.jpg\" alt=\"CONCAT Formula in Excel\" width=\"659\" height=\"137\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01.jpg 659w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01-300x62.jpg 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>CONCAT\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>text1, …<\/strong><\/em><\/span><\/h3>\n<p><strong>Which cells do you want to combine together?<\/strong><\/p>\n<p><em>Select the range of cells that you want to combine together<\/em><\/p>\n<h3>=CONCAT(<span style=\"color: #0000ff;\">C9:E9)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10354\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02.jpg\" alt=\"CONCAT Formula in Excel\" width=\"660\" height=\"156\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02.jpg 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02-300x71.jpg 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10355\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03.jpg\" alt=\"CONCAT Formula in Excel\" width=\"663\" height=\"138\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03.jpg 663w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03-300x62.jpg 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/p>\n<p>You now have your combined text!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10356\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04.jpg\" alt=\"CONCAT Formula in Excel\" width=\"690\" height=\"172\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04.jpg 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04-300x75.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/p>\n<p> <\/p>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"IFS_FORMULA\"><\/span>IFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Checks multiple conditions and returns the value of the first TRUE condition<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=IFS(<span style=\"color: #0000ff;\">logical_test1<\/span>, <span style=\"color: #ff6600;\">value_if_true1<\/span>, <span style=\"color: #339966;\">[logical_test2, value_if_true2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=IFS(<span style=\"color: #0000ff;\">first condition to check<\/span>, <span style=\"color: #ff6600;\">value to return<\/span>, <span style=\"color: #339966;\">[succeeding conditions to check], …<\/span>)<\/p>\n<hr \/>\n<p>If you have multiple logical conditions to check, instead of creating Nested IF Formulas, we can use\u00a0<strong>Excel’s IFS Formula!<\/strong> It allows us to specify multiple conditions to check, then the\u00a0<strong>IFS Formula<\/strong> will look for the first condition that gets satisfied!<\/p>\n<p>Let us try it out on a simple tax table, then we will create an\u00a0<strong>IFS Formula<\/strong> that will simulate the exact same logic of the table!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/is_pnC6Y8K0?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">IFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>IFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=IFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10359\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01.jpg\" alt=\"IFS Formula in Excel\" width=\"739\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01.jpg 739w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01-300x69.jpg 300w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>IFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test1, value_if_true1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the first condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Let us start from the minimum value of the tax table. If the income is less than $8456, then the tax rate is 13%<\/em><\/p>\n<h3>=IFS(<span style=\"color: #0000ff;\">G8<8456, 13%,\u00a0<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10360\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02.jpg\" alt=\"IFS Formula in Excel\" width=\"876\" height=\"143\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02.jpg 876w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02-300x49.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02-768x125.jpg 768w\" sizes=\"(max-width: 876px) 100vw, 876px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test2, value_if_true2<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the second condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Going to the second row, if the income is less than $15874, then the tax rate is 18%<\/em><\/p>\n<h3>=IFS(G8<8456, 13%, <span style=\"color: #0000ff;\">G8<15874, 18%,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10361\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03.jpg\" alt=\"IFS Formula in Excel\" width=\"1018\" height=\"140\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03.jpg 1018w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03-300x41.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03-768x106.jpg 768w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test3, value_if_true3<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the third condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Going to the last row, if the income is greater than or equal to $15874, then the tax rate is 22%<\/em><\/p>\n<h3>=IFS(G8<8456, 13%, G8<15874, 18%, <span style=\"color: #0000ff;\">G8>=15874, 22%)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10362\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04.jpg\" alt=\"IFS Formula in Excel\" width=\"918\" height=\"135\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04.jpg 918w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04-300x44.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04-768x113.jpg 768w\" sizes=\"(max-width: 918px) 100vw, 918px\" \/><\/p>\n<p>You now have your correct tax rate!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10363\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05.jpg\" alt=\"IFS Formula in Excel\" width=\"598\" height=\"153\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05.jpg 598w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05-300x77.jpg 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"MAXIFS_FORMULA\"><\/span>MAXIFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Gets the max value based on the cells that matches the criteria<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=MAXIFS(<span style=\"color: #0000ff;\">max_range<\/span>, <span style=\"color: #ff6600;\">criteria_range1<\/span>, <span style=\"color: #339966;\">criteria1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=MAXIFS(<span style=\"color: #0000ff;\">cells that contains the values<\/span>, <span style=\"color: #ff6600;\">first set of cells to base the filtering on<\/span>, <span style=\"color: #339966;\">filtering condition of first set of cells, …<\/span>)<\/p>\n<hr \/>\n<p>If you need to get the max value while doing filtering at the same time, the\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/maxifs-formula-in-excel-2\/\" target=\"_blank\" rel=\"noopener\">MAXIFS Formula<\/a><\/strong> will do this for you in Excel! This was introduced in Excel 2019.<\/p>\n<p>You need to specify on which ones you want to get the MAX value, then specify one or more conditions used for filtering. In our example, we want to get the maximum sales of John!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Yz-HqB7wQ0k?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">MAXIFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>MAXIFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=MAXIFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10324\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"717\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01.jpg 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01-300x84.jpg 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>MAXIFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>max_range<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values to get the max value?<\/strong><\/p>\n<p><em>Select the cells containing the sales numbers that you want to get the maximum value from:<\/em><\/p>\n<h3>=MAXIFS(<span style=\"color: #0000ff;\">D9:D13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10325\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"725\" height=\"188\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02.jpg 725w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02-300x78.jpg 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria_range1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values for filtering?<\/strong><\/p>\n<p><em>Select the cells containing the sales person names:<\/em><\/p>\n<h3>=MAXIFS(D9:D13, <span style=\"color: #0000ff;\">C9:C13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"779\" height=\"189\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03.jpg 779w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03-300x73.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03-768x186.jpg 768w\" sizes=\"(max-width: 779px) 100vw, 779px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the your filtering criteria?<\/strong><\/p>\n<p><em>Since we want to filter to the sales numbers of John, type in John:<\/em><\/p>\n<h3>=MAXIFS(D9:D13, C9:C13, <span style=\"color: #0000ff;\">“John”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10327\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"532\" height=\"181\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04.jpg 532w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04-300x102.jpg 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/p>\n<p>You now have John’s highest sales number!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10328\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"536\" height=\"183\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05.jpg 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05-300x102.jpg 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"MINIFS_FORMULA\"><\/span>MINIFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Gets the minimum value based on the cells that matches the criteria<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=MINIFS(<span style=\"color: #0000ff;\">min_range<\/span>, <span style=\"color: #ff6600;\">criteria_range1<\/span>, <span style=\"color: #339966;\">criteria1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=MINIFS(<span style=\"color: #0000ff;\">cells that contains the values<\/span>, <span style=\"color: #ff6600;\">first set of cells to base the filtering on<\/span>, <span style=\"color: #339966;\">filtering condition of first set of cells, …<\/span>)<\/p>\n<hr \/>\n<p>If you need to get the minimum value while doing filtering at the same time, the\u00a0<strong>MINIFS Formula<\/strong> will do this for you in Excel! This was introduced in Excel 2019.<\/p>\n<p>You need to specify on which ones you want to get the MIN value, then specify one or more conditions used for filtering. In our example, we want to get the minimum sales of John!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/gBF39acB-uw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">MINIFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>MINIFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=MINIFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10333\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01.jpg\" alt=\"MINIFS Formula in Excel\" width=\"705\" height=\"179\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01.jpg 705w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01-300x76.jpg 300w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>MINIFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>min_range<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values to get the min value?<\/strong><\/p>\n<p><em>Select the cells containing the sales numbers that you want to get the minimum value from:<\/em><\/p>\n<h3>=MINIFS(<span style=\"color: #0000ff;\">D9:D13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10334\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02.jpg\" alt=\"MINIFS Formula in Excel\" width=\"727\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02.jpg 727w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02-300x74.jpg 300w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria_range1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values for filtering?<\/strong><\/p>\n<p><em>Select the cells containing the sales person names:<\/em><\/p>\n<h3>=MINIFS(D9:D13, <span style=\"color: #0000ff;\">C9:C13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10335\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03.jpg\" alt=\"MINIFS Formula in Excel\" width=\"790\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03.jpg 790w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03-300x70.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03-768x180.jpg 768w\" sizes=\"(max-width: 790px) 100vw, 790px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the your filtering criteria?<\/strong><\/p>\n<p><em>Since we want to filter to the sales numbers of John, type in John:<\/em><\/p>\n<h3>=MINIFS(D9:D13, C9:C13, <span style=\"color: #0000ff;\">“John”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10336\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04.jpg\" alt=\"MINIFS Formula in Excel\" width=\"524\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04.jpg 524w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04-300x106.jpg 300w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/p>\n<p>You now have John’s lowest sales number!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10337\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05.jpg\" alt=\"MINIFS Formula in Excel\" width=\"530\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05-300x102.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"SWITCH_FORMULA\"><\/span>SWITCH FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<div>\n<p>Matches multiple values and returns the first value that has a match<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=SWITCH(<span style=\"color: #0000ff;\">expression<\/span>, <span style=\"color: #ff6600;\">value1, result1<\/span>, <span style=\"color: #339966;\">[value2 \/ default, result2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=SWITCH(<span style=\"color: #0000ff;\">value to check<\/span>, <span style=\"color: #ff6600;\">value to match against, result to return<\/span>, <span style=\"color: #339966;\">[succeeding values to match or the default value if nothing gets matched], …<\/span>)<\/p>\n<hr \/>\n<p>If you have multiple values to check, we can use\u00a0<strong>Excel’s SWITCH Formula!<\/strong> It allows us to specify multiple values to check, then the\u00a0<strong>SWITCH Formula<\/strong> will look for the first value that gets matched!<\/p>\n<p>Let us try it out on a simple ratings table (e.g. 1 = Bad, 2 = Average, 3 = Great), then we will create a\u00a0<strong>SWITCH Formula<\/strong> that will simulate the exact same logic of the table!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/dwri-bDOjTg?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">SWITCH-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>SWITCH\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=SWITCH(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10367\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01.jpg\" alt=\"SWITCH Formula in Excel\" width=\"884\" height=\"158\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01.jpg 884w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01-300x54.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01-768x137.jpg 768w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>SWITCH\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>expression<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the value to check?<\/strong><\/p>\n<p><em>Select the cell containing the rating that you want to translate to the correct description<\/em><\/p>\n<h3>=SWITCH(<span style=\"color: #0000ff;\">G8,\u00a0<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10368\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02.jpg\" alt=\"SWITCH Formula in Excel\" width=\"979\" height=\"152\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02.jpg 979w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02-300x47.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02-768x119.jpg 768w\" sizes=\"(max-width: 979px) 100vw, 979px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value1, result1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the first lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the first value of the rating table. If the value is 1, then the description is “Bad”<\/em><\/p>\n<h3>=SWITCH(G8, <span style=\"color: #0000ff;\">1, “Bad”<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10369\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03.jpg\" alt=\"SWITCH Formula in Excel\" width=\"871\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03.jpg 871w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03-300x55.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03-768x141.jpg 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value2, result2<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the second lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the second value of the rating table. If the value is 2, then the description is “Average”<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”,<span style=\"color: #0000ff;\"> 2, “Average”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10370\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04.jpg\" alt=\"SWITCH Formula in Excel\" width=\"942\" height=\"145\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04.jpg 942w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04-300x46.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04-768x118.jpg 768w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value3, result3<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the third lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the third value of the rating table. If the value is 3, then the description is “Great”<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”, 2, “Average”,<span style=\"color: #0000ff;\"> 3, “Great”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10371\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05.jpg\" alt=\"SWITCH Formula in Excel\" width=\"1040\" height=\"156\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05.jpg 1040w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-300x45.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-1024x154.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-768x115.jpg 768w\" sizes=\"(max-width: 1040px) 100vw, 1040px\" \/><\/p>\n<p> <\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>default<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the default value to return if nothing gets matched?<\/strong><\/p>\n<p><em>We want to show the value “Unknown”, if an unknown rating is specified.<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”, 2, “Average”, 3, “Great”, <span style=\"color: #0000ff;\">“Unknown”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10372\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06.jpg\" alt=\"SWITCH Formula in Excel\" width=\"952\" height=\"148\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06.jpg 952w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06-300x47.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06-768x119.jpg 768w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/p>\n<p>You now have your correct rating description!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10373\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07.jpg\" alt=\"SWITCH Formula in Excel\" width=\"610\" height=\"152\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07.jpg 610w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07-300x75.jpg 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/p>\n<p>Let us try an unknown rating (40) and see the resulting description:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10374\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08.jpg\" alt=\"SWITCH Formula in Excel\" width=\"592\" height=\"157\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08.jpg 592w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08-300x80.jpg 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/p>\n<p> <\/p>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"TEXTJOIN_FORMULA\"><\/span>TEXTJOIN FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Concatenates a list with a specified delimiter<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=TEXTJOIN(<span style=\"color: #0000ff;\">delimiter<\/span>, <span style=\"color: #ff6600;\">ignore_empty<\/span>, <span style=\"color: #339966;\">text1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=TEXTJOIN(<span style=\"color: #0000ff;\">the delimiter<\/span>, <span style=\"color: #ff6600;\">ignore empty cells in combining text<\/span>, <span style=\"color: #339966;\">first text\/range to combine, …<\/span>)<\/p>\n<hr \/>\n<p>Do you want to combine text or a range of cells together easily? The\u00a0<strong>TEXTJOIN Formula\u00a0<\/strong>in Excel will do this for you in a flash! The\u00a0<strong>TEXTJOIN Formula\u00a0<\/strong>was introduced in Excel 2019.<\/p>\n<p>It can even let you specify a <strong>delimiter<\/strong> to use to combine the text together and <strong>ignore empty cells<\/strong> for you!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Xy6iJNmvZfM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">TEXTJOIN-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>TEXTJOIN\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=TEXTJOIN(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10339\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"752\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01.jpg 752w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01-300x57.jpg 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>TEXTJOIN\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>delimiter<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the delimiter to use in combining the text?<\/strong><\/p>\n<p><em>We want to have the text combined together and separated by a comma:<\/em><\/p>\n<h3>=TEXTJOIN(<span style=\"color: #0000ff;\">“,”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10340\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"786\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02.jpg 786w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02-300x62.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02-768x159.jpg 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>ignore_empty<\/strong><\/em><\/span><\/h3>\n<p><strong>Do you want to ignore the empty cells?<\/strong><\/p>\n<p><em>Let us set this to TRUE to ignore the empty cells when combining them together:<\/em><\/p>\n<h3>=TEXTJOIN(“,”,\u00a0<span style=\"color: #0000ff;\">TRUE,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10341\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"835\" height=\"140\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03.jpg 835w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03-300x50.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03-768x129.jpg 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>text1, …<\/strong><\/em><\/span><\/h3>\n<p><strong>Which cells do you want to combine together?<\/strong><\/p>\n<p><em>Select the range of cells that you want to combine together<\/em><\/p>\n<h3>=TEXTJOIN(“,”,\u00a0TRUE,<span style=\"color: #0000ff;\"> C9:E9)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10342\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"706\" height=\"141\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04.jpg 706w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04-300x60.jpg 300w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10343\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"660\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05.jpg 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05-300x65.jpg 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p>You now have your combined text!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10344\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"683\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06.jpg 683w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06-300x72.jpg 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/p>\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is your one stop shop on learning the new formulas in Excel 2019: CONCAT, IFS, MAXIFS, MINIFS, SWITCH and TEXTJOIN! Want to Master the New Formulas in Excel 2019? *** Watch our video and step by step guide below with free downloadable Excel workbook to practice *** ? Watch on YouTube and give it […]<\/p>\n","protected":false},"author":2,"featured_media":16425,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[14,3],"tags":[554,142,556,560,562,558,70,552],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13752"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=13752"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/16425"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=13752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=13752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=13752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Table of Contents<\/p>\n<\/span><\/div>\nFree Practice Workbook<\/a><\/li>Want to Master the New Formulas in Excel 2019?<\/a><\/li>CONCAT FORMULA<\/a><\/li>IFS FORMULA<\/a><\/li>MAXIFS FORMULA<\/a><\/li>MINIFS FORMULA<\/a><\/li>SWITCH FORMULA<\/a><\/li>TEXTJOIN FORMULA<\/a><\/li><\/ul><\/nav><\/div>\n<\/span>Want to Master the New Formulas in Excel 2019?<\/strong><\/em><\/span><\/h2>\n*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/8cCCRqT835Q\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up ??<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"CONCAT_FORMULA\"><\/span>CONCAT FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Concatenates a list together without a delimiter<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=CONCAT(<span style=\"color: #0000ff;\">text1<\/span>, <span style=\"color: #ff6600;\">[text2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=CONCAT(<span style=\"color: #0000ff;\">first text to combine<\/span>, <span style=\"color: #ff6600;\">[second text to combine], …<\/span>)<\/p>\n<hr \/>\n<p>Do you want to combine text or a range of cells together easily? The\u00a0<strong>CONCAT Formula\u00a0<\/strong>in Excel will do this for you in a flash! The\u00a0<strong>CONCAT Formula\u00a0<\/strong>was introduced in Excel 2019.<\/p>\n<p>It will simply combine the text you specify together into a single text.<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0ec59hlQkvw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">CONCAT-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<h3><\/h3>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>CONCAT\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=CONCAT(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10353\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01.jpg\" alt=\"CONCAT Formula in Excel\" width=\"659\" height=\"137\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01.jpg 659w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01-300x62.jpg 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>CONCAT\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>text1, …<\/strong><\/em><\/span><\/h3>\n<p><strong>Which cells do you want to combine together?<\/strong><\/p>\n<p><em>Select the range of cells that you want to combine together<\/em><\/p>\n<h3>=CONCAT(<span style=\"color: #0000ff;\">C9:E9)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10354\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02.jpg\" alt=\"CONCAT Formula in Excel\" width=\"660\" height=\"156\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02.jpg 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02-300x71.jpg 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10355\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03.jpg\" alt=\"CONCAT Formula in Excel\" width=\"663\" height=\"138\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03.jpg 663w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03-300x62.jpg 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/p>\n<p>You now have your combined text!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10356\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04.jpg\" alt=\"CONCAT Formula in Excel\" width=\"690\" height=\"172\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04.jpg 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04-300x75.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/p>\n<p> <\/p>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"IFS_FORMULA\"><\/span>IFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Checks multiple conditions and returns the value of the first TRUE condition<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=IFS(<span style=\"color: #0000ff;\">logical_test1<\/span>, <span style=\"color: #ff6600;\">value_if_true1<\/span>, <span style=\"color: #339966;\">[logical_test2, value_if_true2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=IFS(<span style=\"color: #0000ff;\">first condition to check<\/span>, <span style=\"color: #ff6600;\">value to return<\/span>, <span style=\"color: #339966;\">[succeeding conditions to check], …<\/span>)<\/p>\n<hr \/>\n<p>If you have multiple logical conditions to check, instead of creating Nested IF Formulas, we can use\u00a0<strong>Excel’s IFS Formula!<\/strong> It allows us to specify multiple conditions to check, then the\u00a0<strong>IFS Formula<\/strong> will look for the first condition that gets satisfied!<\/p>\n<p>Let us try it out on a simple tax table, then we will create an\u00a0<strong>IFS Formula<\/strong> that will simulate the exact same logic of the table!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/is_pnC6Y8K0?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">IFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>IFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=IFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10359\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01.jpg\" alt=\"IFS Formula in Excel\" width=\"739\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01.jpg 739w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01-300x69.jpg 300w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>IFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test1, value_if_true1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the first condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Let us start from the minimum value of the tax table. If the income is less than $8456, then the tax rate is 13%<\/em><\/p>\n<h3>=IFS(<span style=\"color: #0000ff;\">G8<8456, 13%,\u00a0<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10360\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02.jpg\" alt=\"IFS Formula in Excel\" width=\"876\" height=\"143\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02.jpg 876w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02-300x49.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02-768x125.jpg 768w\" sizes=\"(max-width: 876px) 100vw, 876px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test2, value_if_true2<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the second condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Going to the second row, if the income is less than $15874, then the tax rate is 18%<\/em><\/p>\n<h3>=IFS(G8<8456, 13%, <span style=\"color: #0000ff;\">G8<15874, 18%,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10361\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03.jpg\" alt=\"IFS Formula in Excel\" width=\"1018\" height=\"140\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03.jpg 1018w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03-300x41.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03-768x106.jpg 768w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test3, value_if_true3<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the third condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Going to the last row, if the income is greater than or equal to $15874, then the tax rate is 22%<\/em><\/p>\n<h3>=IFS(G8<8456, 13%, G8<15874, 18%, <span style=\"color: #0000ff;\">G8>=15874, 22%)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10362\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04.jpg\" alt=\"IFS Formula in Excel\" width=\"918\" height=\"135\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04.jpg 918w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04-300x44.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04-768x113.jpg 768w\" sizes=\"(max-width: 918px) 100vw, 918px\" \/><\/p>\n<p>You now have your correct tax rate!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10363\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05.jpg\" alt=\"IFS Formula in Excel\" width=\"598\" height=\"153\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05.jpg 598w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05-300x77.jpg 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"MAXIFS_FORMULA\"><\/span>MAXIFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Gets the max value based on the cells that matches the criteria<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=MAXIFS(<span style=\"color: #0000ff;\">max_range<\/span>, <span style=\"color: #ff6600;\">criteria_range1<\/span>, <span style=\"color: #339966;\">criteria1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=MAXIFS(<span style=\"color: #0000ff;\">cells that contains the values<\/span>, <span style=\"color: #ff6600;\">first set of cells to base the filtering on<\/span>, <span style=\"color: #339966;\">filtering condition of first set of cells, …<\/span>)<\/p>\n<hr \/>\n<p>If you need to get the max value while doing filtering at the same time, the\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/maxifs-formula-in-excel-2\/\" target=\"_blank\" rel=\"noopener\">MAXIFS Formula<\/a><\/strong> will do this for you in Excel! This was introduced in Excel 2019.<\/p>\n<p>You need to specify on which ones you want to get the MAX value, then specify one or more conditions used for filtering. In our example, we want to get the maximum sales of John!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Yz-HqB7wQ0k?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">MAXIFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>MAXIFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=MAXIFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10324\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"717\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01.jpg 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01-300x84.jpg 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>MAXIFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>max_range<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values to get the max value?<\/strong><\/p>\n<p><em>Select the cells containing the sales numbers that you want to get the maximum value from:<\/em><\/p>\n<h3>=MAXIFS(<span style=\"color: #0000ff;\">D9:D13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10325\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"725\" height=\"188\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02.jpg 725w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02-300x78.jpg 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria_range1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values for filtering?<\/strong><\/p>\n<p><em>Select the cells containing the sales person names:<\/em><\/p>\n<h3>=MAXIFS(D9:D13, <span style=\"color: #0000ff;\">C9:C13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"779\" height=\"189\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03.jpg 779w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03-300x73.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03-768x186.jpg 768w\" sizes=\"(max-width: 779px) 100vw, 779px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the your filtering criteria?<\/strong><\/p>\n<p><em>Since we want to filter to the sales numbers of John, type in John:<\/em><\/p>\n<h3>=MAXIFS(D9:D13, C9:C13, <span style=\"color: #0000ff;\">“John”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10327\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"532\" height=\"181\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04.jpg 532w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04-300x102.jpg 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/p>\n<p>You now have John’s highest sales number!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10328\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"536\" height=\"183\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05.jpg 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05-300x102.jpg 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"MINIFS_FORMULA\"><\/span>MINIFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Gets the minimum value based on the cells that matches the criteria<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=MINIFS(<span style=\"color: #0000ff;\">min_range<\/span>, <span style=\"color: #ff6600;\">criteria_range1<\/span>, <span style=\"color: #339966;\">criteria1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=MINIFS(<span style=\"color: #0000ff;\">cells that contains the values<\/span>, <span style=\"color: #ff6600;\">first set of cells to base the filtering on<\/span>, <span style=\"color: #339966;\">filtering condition of first set of cells, …<\/span>)<\/p>\n<hr \/>\n<p>If you need to get the minimum value while doing filtering at the same time, the\u00a0<strong>MINIFS Formula<\/strong> will do this for you in Excel! This was introduced in Excel 2019.<\/p>\n<p>You need to specify on which ones you want to get the MIN value, then specify one or more conditions used for filtering. In our example, we want to get the minimum sales of John!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/gBF39acB-uw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">MINIFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>MINIFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=MINIFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10333\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01.jpg\" alt=\"MINIFS Formula in Excel\" width=\"705\" height=\"179\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01.jpg 705w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01-300x76.jpg 300w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>MINIFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>min_range<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values to get the min value?<\/strong><\/p>\n<p><em>Select the cells containing the sales numbers that you want to get the minimum value from:<\/em><\/p>\n<h3>=MINIFS(<span style=\"color: #0000ff;\">D9:D13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10334\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02.jpg\" alt=\"MINIFS Formula in Excel\" width=\"727\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02.jpg 727w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02-300x74.jpg 300w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria_range1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values for filtering?<\/strong><\/p>\n<p><em>Select the cells containing the sales person names:<\/em><\/p>\n<h3>=MINIFS(D9:D13, <span style=\"color: #0000ff;\">C9:C13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10335\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03.jpg\" alt=\"MINIFS Formula in Excel\" width=\"790\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03.jpg 790w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03-300x70.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03-768x180.jpg 768w\" sizes=\"(max-width: 790px) 100vw, 790px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the your filtering criteria?<\/strong><\/p>\n<p><em>Since we want to filter to the sales numbers of John, type in John:<\/em><\/p>\n<h3>=MINIFS(D9:D13, C9:C13, <span style=\"color: #0000ff;\">“John”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10336\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04.jpg\" alt=\"MINIFS Formula in Excel\" width=\"524\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04.jpg 524w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04-300x106.jpg 300w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/p>\n<p>You now have John’s lowest sales number!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10337\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05.jpg\" alt=\"MINIFS Formula in Excel\" width=\"530\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05-300x102.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"SWITCH_FORMULA\"><\/span>SWITCH FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<div>\n<p>Matches multiple values and returns the first value that has a match<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=SWITCH(<span style=\"color: #0000ff;\">expression<\/span>, <span style=\"color: #ff6600;\">value1, result1<\/span>, <span style=\"color: #339966;\">[value2 \/ default, result2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=SWITCH(<span style=\"color: #0000ff;\">value to check<\/span>, <span style=\"color: #ff6600;\">value to match against, result to return<\/span>, <span style=\"color: #339966;\">[succeeding values to match or the default value if nothing gets matched], …<\/span>)<\/p>\n<hr \/>\n<p>If you have multiple values to check, we can use\u00a0<strong>Excel’s SWITCH Formula!<\/strong> It allows us to specify multiple values to check, then the\u00a0<strong>SWITCH Formula<\/strong> will look for the first value that gets matched!<\/p>\n<p>Let us try it out on a simple ratings table (e.g. 1 = Bad, 2 = Average, 3 = Great), then we will create a\u00a0<strong>SWITCH Formula<\/strong> that will simulate the exact same logic of the table!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/dwri-bDOjTg?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">SWITCH-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>SWITCH\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=SWITCH(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10367\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01.jpg\" alt=\"SWITCH Formula in Excel\" width=\"884\" height=\"158\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01.jpg 884w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01-300x54.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01-768x137.jpg 768w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>SWITCH\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>expression<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the value to check?<\/strong><\/p>\n<p><em>Select the cell containing the rating that you want to translate to the correct description<\/em><\/p>\n<h3>=SWITCH(<span style=\"color: #0000ff;\">G8,\u00a0<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10368\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02.jpg\" alt=\"SWITCH Formula in Excel\" width=\"979\" height=\"152\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02.jpg 979w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02-300x47.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02-768x119.jpg 768w\" sizes=\"(max-width: 979px) 100vw, 979px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value1, result1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the first lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the first value of the rating table. If the value is 1, then the description is “Bad”<\/em><\/p>\n<h3>=SWITCH(G8, <span style=\"color: #0000ff;\">1, “Bad”<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10369\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03.jpg\" alt=\"SWITCH Formula in Excel\" width=\"871\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03.jpg 871w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03-300x55.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03-768x141.jpg 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value2, result2<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the second lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the second value of the rating table. If the value is 2, then the description is “Average”<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”,<span style=\"color: #0000ff;\"> 2, “Average”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10370\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04.jpg\" alt=\"SWITCH Formula in Excel\" width=\"942\" height=\"145\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04.jpg 942w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04-300x46.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04-768x118.jpg 768w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value3, result3<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the third lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the third value of the rating table. If the value is 3, then the description is “Great”<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”, 2, “Average”,<span style=\"color: #0000ff;\"> 3, “Great”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10371\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05.jpg\" alt=\"SWITCH Formula in Excel\" width=\"1040\" height=\"156\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05.jpg 1040w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-300x45.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-1024x154.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-768x115.jpg 768w\" sizes=\"(max-width: 1040px) 100vw, 1040px\" \/><\/p>\n<p> <\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>default<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the default value to return if nothing gets matched?<\/strong><\/p>\n<p><em>We want to show the value “Unknown”, if an unknown rating is specified.<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”, 2, “Average”, 3, “Great”, <span style=\"color: #0000ff;\">“Unknown”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10372\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06.jpg\" alt=\"SWITCH Formula in Excel\" width=\"952\" height=\"148\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06.jpg 952w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06-300x47.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06-768x119.jpg 768w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/p>\n<p>You now have your correct rating description!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10373\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07.jpg\" alt=\"SWITCH Formula in Excel\" width=\"610\" height=\"152\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07.jpg 610w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07-300x75.jpg 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/p>\n<p>Let us try an unknown rating (40) and see the resulting description:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10374\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08.jpg\" alt=\"SWITCH Formula in Excel\" width=\"592\" height=\"157\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08.jpg 592w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08-300x80.jpg 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/p>\n<p> <\/p>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"TEXTJOIN_FORMULA\"><\/span>TEXTJOIN FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Concatenates a list with a specified delimiter<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=TEXTJOIN(<span style=\"color: #0000ff;\">delimiter<\/span>, <span style=\"color: #ff6600;\">ignore_empty<\/span>, <span style=\"color: #339966;\">text1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=TEXTJOIN(<span style=\"color: #0000ff;\">the delimiter<\/span>, <span style=\"color: #ff6600;\">ignore empty cells in combining text<\/span>, <span style=\"color: #339966;\">first text\/range to combine, …<\/span>)<\/p>\n<hr \/>\n<p>Do you want to combine text or a range of cells together easily? The\u00a0<strong>TEXTJOIN Formula\u00a0<\/strong>in Excel will do this for you in a flash! The\u00a0<strong>TEXTJOIN Formula\u00a0<\/strong>was introduced in Excel 2019.<\/p>\n<p>It can even let you specify a <strong>delimiter<\/strong> to use to combine the text together and <strong>ignore empty cells<\/strong> for you!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Xy6iJNmvZfM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">TEXTJOIN-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>TEXTJOIN\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=TEXTJOIN(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10339\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"752\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01.jpg 752w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01-300x57.jpg 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>TEXTJOIN\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>delimiter<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the delimiter to use in combining the text?<\/strong><\/p>\n<p><em>We want to have the text combined together and separated by a comma:<\/em><\/p>\n<h3>=TEXTJOIN(<span style=\"color: #0000ff;\">“,”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10340\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"786\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02.jpg 786w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02-300x62.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02-768x159.jpg 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>ignore_empty<\/strong><\/em><\/span><\/h3>\n<p><strong>Do you want to ignore the empty cells?<\/strong><\/p>\n<p><em>Let us set this to TRUE to ignore the empty cells when combining them together:<\/em><\/p>\n<h3>=TEXTJOIN(“,”,\u00a0<span style=\"color: #0000ff;\">TRUE,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10341\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"835\" height=\"140\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03.jpg 835w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03-300x50.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03-768x129.jpg 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>text1, …<\/strong><\/em><\/span><\/h3>\n<p><strong>Which cells do you want to combine together?<\/strong><\/p>\n<p><em>Select the range of cells that you want to combine together<\/em><\/p>\n<h3>=TEXTJOIN(“,”,\u00a0TRUE,<span style=\"color: #0000ff;\"> C9:E9)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10342\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"706\" height=\"141\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04.jpg 706w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04-300x60.jpg 300w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10343\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"660\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05.jpg 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05-300x65.jpg 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p>You now have your combined text!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10344\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"683\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06.jpg 683w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06-300x72.jpg 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/p>\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is your one stop shop on learning the new formulas in Excel 2019: CONCAT, IFS, MAXIFS, MINIFS, SWITCH and TEXTJOIN! Want to Master the New Formulas in Excel 2019? *** Watch our video and step by step guide below with free downloadable Excel workbook to practice *** ? Watch on YouTube and give it […]<\/p>\n","protected":false},"author":2,"featured_media":16425,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[14,3],"tags":[554,142,556,560,562,558,70,552],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13752"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=13752"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/16425"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=13752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=13752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=13752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n
<span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/8cCCRqT835Q\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up ??<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"CONCAT_FORMULA\"><\/span>CONCAT FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Concatenates a list together without a delimiter<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=CONCAT(<span style=\"color: #0000ff;\">text1<\/span>, <span style=\"color: #ff6600;\">[text2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=CONCAT(<span style=\"color: #0000ff;\">first text to combine<\/span>, <span style=\"color: #ff6600;\">[second text to combine], …<\/span>)<\/p>\n<hr \/>\n<p>Do you want to combine text or a range of cells together easily? The\u00a0<strong>CONCAT Formula\u00a0<\/strong>in Excel will do this for you in a flash! The\u00a0<strong>CONCAT Formula\u00a0<\/strong>was introduced in Excel 2019.<\/p>\n<p>It will simply combine the text you specify together into a single text.<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0ec59hlQkvw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">CONCAT-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<h3><\/h3>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>CONCAT\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=CONCAT(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10353\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01.jpg\" alt=\"CONCAT Formula in Excel\" width=\"659\" height=\"137\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01.jpg 659w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-01-300x62.jpg 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>CONCAT\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>text1, …<\/strong><\/em><\/span><\/h3>\n<p><strong>Which cells do you want to combine together?<\/strong><\/p>\n<p><em>Select the range of cells that you want to combine together<\/em><\/p>\n<h3>=CONCAT(<span style=\"color: #0000ff;\">C9:E9)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10354\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02.jpg\" alt=\"CONCAT Formula in Excel\" width=\"660\" height=\"156\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02.jpg 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-02-300x71.jpg 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10355\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03.jpg\" alt=\"CONCAT Formula in Excel\" width=\"663\" height=\"138\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03.jpg 663w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-03-300x62.jpg 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/p>\n<p>You now have your combined text!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONCAT Formula in Excel\" class=\"aligncenter size-full wp-image-10356\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04.jpg\" alt=\"CONCAT Formula in Excel\" width=\"690\" height=\"172\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04.jpg 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONCAT-FORMULA-04-300x75.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/p>\n<p> <\/p>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"IFS_FORMULA\"><\/span>IFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Checks multiple conditions and returns the value of the first TRUE condition<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=IFS(<span style=\"color: #0000ff;\">logical_test1<\/span>, <span style=\"color: #ff6600;\">value_if_true1<\/span>, <span style=\"color: #339966;\">[logical_test2, value_if_true2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=IFS(<span style=\"color: #0000ff;\">first condition to check<\/span>, <span style=\"color: #ff6600;\">value to return<\/span>, <span style=\"color: #339966;\">[succeeding conditions to check], …<\/span>)<\/p>\n<hr \/>\n<p>If you have multiple logical conditions to check, instead of creating Nested IF Formulas, we can use\u00a0<strong>Excel’s IFS Formula!<\/strong> It allows us to specify multiple conditions to check, then the\u00a0<strong>IFS Formula<\/strong> will look for the first condition that gets satisfied!<\/p>\n<p>Let us try it out on a simple tax table, then we will create an\u00a0<strong>IFS Formula<\/strong> that will simulate the exact same logic of the table!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/is_pnC6Y8K0?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">IFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>IFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=IFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10359\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01.jpg\" alt=\"IFS Formula in Excel\" width=\"739\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01.jpg 739w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-01-300x69.jpg 300w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>IFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test1, value_if_true1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the first condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Let us start from the minimum value of the tax table. If the income is less than $8456, then the tax rate is 13%<\/em><\/p>\n<h3>=IFS(<span style=\"color: #0000ff;\">G8<8456, 13%,\u00a0<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10360\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02.jpg\" alt=\"IFS Formula in Excel\" width=\"876\" height=\"143\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02.jpg 876w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02-300x49.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-02-768x125.jpg 768w\" sizes=\"(max-width: 876px) 100vw, 876px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test2, value_if_true2<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the second condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Going to the second row, if the income is less than $15874, then the tax rate is 18%<\/em><\/p>\n<h3>=IFS(G8<8456, 13%, <span style=\"color: #0000ff;\">G8<15874, 18%,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10361\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03.jpg\" alt=\"IFS Formula in Excel\" width=\"1018\" height=\"140\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03.jpg 1018w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03-300x41.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-03-768x106.jpg 768w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>logical_test3, value_if_true3<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the third condition and value to return if the condition is met?<\/strong><\/p>\n<p><em>Going to the last row, if the income is greater than or equal to $15874, then the tax rate is 22%<\/em><\/p>\n<h3>=IFS(G8<8456, 13%, G8<15874, 18%, <span style=\"color: #0000ff;\">G8>=15874, 22%)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10362\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04.jpg\" alt=\"IFS Formula in Excel\" width=\"918\" height=\"135\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04.jpg 918w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04-300x44.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-04-768x113.jpg 768w\" sizes=\"(max-width: 918px) 100vw, 918px\" \/><\/p>\n<p>You now have your correct tax rate!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"IFS Formula in Excel\" class=\"aligncenter size-full wp-image-10363\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05.jpg\" alt=\"IFS Formula in Excel\" width=\"598\" height=\"153\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05.jpg 598w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/IFS-FORMULA-05-300x77.jpg 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"MAXIFS_FORMULA\"><\/span>MAXIFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Gets the max value based on the cells that matches the criteria<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=MAXIFS(<span style=\"color: #0000ff;\">max_range<\/span>, <span style=\"color: #ff6600;\">criteria_range1<\/span>, <span style=\"color: #339966;\">criteria1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=MAXIFS(<span style=\"color: #0000ff;\">cells that contains the values<\/span>, <span style=\"color: #ff6600;\">first set of cells to base the filtering on<\/span>, <span style=\"color: #339966;\">filtering condition of first set of cells, …<\/span>)<\/p>\n<hr \/>\n<p>If you need to get the max value while doing filtering at the same time, the\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/maxifs-formula-in-excel-2\/\" target=\"_blank\" rel=\"noopener\">MAXIFS Formula<\/a><\/strong> will do this for you in Excel! This was introduced in Excel 2019.<\/p>\n<p>You need to specify on which ones you want to get the MAX value, then specify one or more conditions used for filtering. In our example, we want to get the maximum sales of John!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Yz-HqB7wQ0k?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">MAXIFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>MAXIFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=MAXIFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10324\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"717\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01.jpg 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-01-300x84.jpg 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>MAXIFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>max_range<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values to get the max value?<\/strong><\/p>\n<p><em>Select the cells containing the sales numbers that you want to get the maximum value from:<\/em><\/p>\n<h3>=MAXIFS(<span style=\"color: #0000ff;\">D9:D13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10325\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"725\" height=\"188\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02.jpg 725w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-02-300x78.jpg 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria_range1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values for filtering?<\/strong><\/p>\n<p><em>Select the cells containing the sales person names:<\/em><\/p>\n<h3>=MAXIFS(D9:D13, <span style=\"color: #0000ff;\">C9:C13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"779\" height=\"189\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03.jpg 779w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03-300x73.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-03-768x186.jpg 768w\" sizes=\"(max-width: 779px) 100vw, 779px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the your filtering criteria?<\/strong><\/p>\n<p><em>Since we want to filter to the sales numbers of John, type in John:<\/em><\/p>\n<h3>=MAXIFS(D9:D13, C9:C13, <span style=\"color: #0000ff;\">“John”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10327\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"532\" height=\"181\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04.jpg 532w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-04-300x102.jpg 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/p>\n<p>You now have John’s highest sales number!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MAXIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10328\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05.jpg\" alt=\"MAXIFS Formula in Excel\" width=\"536\" height=\"183\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05.jpg 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MAXIFS-FORMULA-05-300x102.jpg 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"MINIFS_FORMULA\"><\/span>MINIFS FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Gets the minimum value based on the cells that matches the criteria<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=MINIFS(<span style=\"color: #0000ff;\">min_range<\/span>, <span style=\"color: #ff6600;\">criteria_range1<\/span>, <span style=\"color: #339966;\">criteria1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=MINIFS(<span style=\"color: #0000ff;\">cells that contains the values<\/span>, <span style=\"color: #ff6600;\">first set of cells to base the filtering on<\/span>, <span style=\"color: #339966;\">filtering condition of first set of cells, …<\/span>)<\/p>\n<hr \/>\n<p>If you need to get the minimum value while doing filtering at the same time, the\u00a0<strong>MINIFS Formula<\/strong> will do this for you in Excel! This was introduced in Excel 2019.<\/p>\n<p>You need to specify on which ones you want to get the MIN value, then specify one or more conditions used for filtering. In our example, we want to get the minimum sales of John!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/gBF39acB-uw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">MINIFS-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>MINIFS\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=MINIFS(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10333\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01.jpg\" alt=\"MINIFS Formula in Excel\" width=\"705\" height=\"179\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01.jpg 705w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-01-300x76.jpg 300w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>MINIFS\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>min_range<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values to get the min value?<\/strong><\/p>\n<p><em>Select the cells containing the sales numbers that you want to get the minimum value from:<\/em><\/p>\n<h3>=MINIFS(<span style=\"color: #0000ff;\">D9:D13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10334\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02.jpg\" alt=\"MINIFS Formula in Excel\" width=\"727\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02.jpg 727w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-02-300x74.jpg 300w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria_range1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the range that contains the values for filtering?<\/strong><\/p>\n<p><em>Select the cells containing the sales person names:<\/em><\/p>\n<h3>=MINIFS(D9:D13, <span style=\"color: #0000ff;\">C9:C13,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10335\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03.jpg\" alt=\"MINIFS Formula in Excel\" width=\"790\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03.jpg 790w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03-300x70.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-03-768x180.jpg 768w\" sizes=\"(max-width: 790px) 100vw, 790px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>criteria1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the your filtering criteria?<\/strong><\/p>\n<p><em>Since we want to filter to the sales numbers of John, type in John:<\/em><\/p>\n<h3>=MINIFS(D9:D13, C9:C13, <span style=\"color: #0000ff;\">“John”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10336\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04.jpg\" alt=\"MINIFS Formula in Excel\" width=\"524\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04.jpg 524w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-04-300x106.jpg 300w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/p>\n<p>You now have John’s lowest sales number!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"MINIFS Formula in Excel\" class=\"aligncenter size-full wp-image-10337\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05.jpg\" alt=\"MINIFS Formula in Excel\" width=\"530\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/MINIFS-FORMULA-05-300x102.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/p>\n<p> <\/p>\n<h2><span class=\"ez-toc-section\" id=\"SWITCH_FORMULA\"><\/span>SWITCH FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<div>\n<p>Matches multiple values and returns the first value that has a match<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=SWITCH(<span style=\"color: #0000ff;\">expression<\/span>, <span style=\"color: #ff6600;\">value1, result1<\/span>, <span style=\"color: #339966;\">[value2 \/ default, result2], …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=SWITCH(<span style=\"color: #0000ff;\">value to check<\/span>, <span style=\"color: #ff6600;\">value to match against, result to return<\/span>, <span style=\"color: #339966;\">[succeeding values to match or the default value if nothing gets matched], …<\/span>)<\/p>\n<hr \/>\n<p>If you have multiple values to check, we can use\u00a0<strong>Excel’s SWITCH Formula!<\/strong> It allows us to specify multiple values to check, then the\u00a0<strong>SWITCH Formula<\/strong> will look for the first value that gets matched!<\/p>\n<p>Let us try it out on a simple ratings table (e.g. 1 = Bad, 2 = Average, 3 = Great), then we will create a\u00a0<strong>SWITCH Formula<\/strong> that will simulate the exact same logic of the table!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/dwri-bDOjTg?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">SWITCH-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>SWITCH\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=SWITCH(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10367\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01.jpg\" alt=\"SWITCH Formula in Excel\" width=\"884\" height=\"158\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01.jpg 884w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01-300x54.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-01-768x137.jpg 768w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>SWITCH\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>expression<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the value to check?<\/strong><\/p>\n<p><em>Select the cell containing the rating that you want to translate to the correct description<\/em><\/p>\n<h3>=SWITCH(<span style=\"color: #0000ff;\">G8,\u00a0<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10368\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02.jpg\" alt=\"SWITCH Formula in Excel\" width=\"979\" height=\"152\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02.jpg 979w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02-300x47.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-02-768x119.jpg 768w\" sizes=\"(max-width: 979px) 100vw, 979px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value1, result1<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the first lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the first value of the rating table. If the value is 1, then the description is “Bad”<\/em><\/p>\n<h3>=SWITCH(G8, <span style=\"color: #0000ff;\">1, “Bad”<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10369\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03.jpg\" alt=\"SWITCH Formula in Excel\" width=\"871\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03.jpg 871w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03-300x55.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-03-768x141.jpg 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value2, result2<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the second lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the second value of the rating table. If the value is 2, then the description is “Average”<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”,<span style=\"color: #0000ff;\"> 2, “Average”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10370\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04.jpg\" alt=\"SWITCH Formula in Excel\" width=\"942\" height=\"145\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04.jpg 942w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04-300x46.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-04-768x118.jpg 768w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>value3, result3<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the third lookup value and value to return if it is matched?<\/strong><\/p>\n<p><em>Let us start from the third value of the rating table. If the value is 3, then the description is “Great”<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”, 2, “Average”,<span style=\"color: #0000ff;\"> 3, “Great”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10371\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05.jpg\" alt=\"SWITCH Formula in Excel\" width=\"1040\" height=\"156\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05.jpg 1040w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-300x45.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-1024x154.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-05-768x115.jpg 768w\" sizes=\"(max-width: 1040px) 100vw, 1040px\" \/><\/p>\n<p> <\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>default<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the default value to return if nothing gets matched?<\/strong><\/p>\n<p><em>We want to show the value “Unknown”, if an unknown rating is specified.<\/em><\/p>\n<h3>=SWITCH(G8, 1, “Bad”, 2, “Average”, 3, “Great”, <span style=\"color: #0000ff;\">“Unknown”)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10372\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06.jpg\" alt=\"SWITCH Formula in Excel\" width=\"952\" height=\"148\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06.jpg 952w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06-300x47.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-06-768x119.jpg 768w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/p>\n<p>You now have your correct rating description!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10373\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07.jpg\" alt=\"SWITCH Formula in Excel\" width=\"610\" height=\"152\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07.jpg 610w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-07-300x75.jpg 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/p>\n<p>Let us try an unknown rating (40) and see the resulting description:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"SWITCH Formula in Excel\" class=\"aligncenter size-full wp-image-10374\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08.jpg\" alt=\"SWITCH Formula in Excel\" width=\"592\" height=\"157\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08.jpg 592w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/SWITCH-FORMULA-08-300x80.jpg 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/p>\n<p> <\/p>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"TEXTJOIN_FORMULA\"><\/span>TEXTJOIN FORMULA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Concatenates a list with a specified delimiter<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=TEXTJOIN(<span style=\"color: #0000ff;\">delimiter<\/span>, <span style=\"color: #ff6600;\">ignore_empty<\/span>, <span style=\"color: #339966;\">text1, …<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=TEXTJOIN(<span style=\"color: #0000ff;\">the delimiter<\/span>, <span style=\"color: #ff6600;\">ignore empty cells in combining text<\/span>, <span style=\"color: #339966;\">first text\/range to combine, …<\/span>)<\/p>\n<hr \/>\n<p>Do you want to combine text or a range of cells together easily? The\u00a0<strong>TEXTJOIN Formula\u00a0<\/strong>in Excel will do this for you in a flash! The\u00a0<strong>TEXTJOIN Formula\u00a0<\/strong>was introduced in Excel 2019.<\/p>\n<p>It can even let you specify a <strong>delimiter<\/strong> to use to combine the text together and <strong>ignore empty cells<\/strong> for you!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Xy6iJNmvZfM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">?<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">TEXTJOIN-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>TEXTJOIN\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h3><span style=\"color: #0000ff;\">=TEXTJOIN(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10339\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"752\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01.jpg 752w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-01-300x57.jpg 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/p>\n<p> <\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>TEXTJOIN\u00a0<\/b>arguments:<\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>delimiter<\/strong><\/em><\/span><\/h3>\n<p><strong>What is the delimiter to use in combining the text?<\/strong><\/p>\n<p><em>We want to have the text combined together and separated by a comma:<\/em><\/p>\n<h3>=TEXTJOIN(<span style=\"color: #0000ff;\">“,”,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10340\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"786\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02.jpg 786w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02-300x62.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-02-768x159.jpg 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>ignore_empty<\/strong><\/em><\/span><\/h3>\n<p><strong>Do you want to ignore the empty cells?<\/strong><\/p>\n<p><em>Let us set this to TRUE to ignore the empty cells when combining them together:<\/em><\/p>\n<h3>=TEXTJOIN(“,”,\u00a0<span style=\"color: #0000ff;\">TRUE,<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10341\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"835\" height=\"140\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03.jpg 835w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03-300x50.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-03-768x129.jpg 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/p>\n<h3><span style=\"color: #0000ff;\"><em><strong>text1, …<\/strong><\/em><\/span><\/h3>\n<p><strong>Which cells do you want to combine together?<\/strong><\/p>\n<p><em>Select the range of cells that you want to combine together<\/em><\/p>\n<h3>=TEXTJOIN(“,”,\u00a0TRUE,<span style=\"color: #0000ff;\"> C9:E9)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10342\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"706\" height=\"141\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04.jpg 706w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-04-300x60.jpg 300w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10343\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"660\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05.jpg 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-05-300x65.jpg 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p>You now have your combined text!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"TEXTJOIN Formula in Excel\" class=\"aligncenter size-full wp-image-10344\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06.jpg\" alt=\"TEXTJOIN Formula in Excel\" width=\"683\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06.jpg 683w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/TEXTJOIN-FORMULA-06-300x72.jpg 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/p>\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is your one stop shop on learning the new formulas in Excel 2019: CONCAT, IFS, MAXIFS, MINIFS, SWITCH and TEXTJOIN! Want to Master the New Formulas in Excel 2019? *** Watch our video and step by step guide below with free downloadable Excel workbook to practice *** ? Watch on YouTube and give it […]<\/p>\n","protected":false},"author":2,"featured_media":16425,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[14,3],"tags":[554,142,556,560,562,558,70,552],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13752"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=13752"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/16425"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=13752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=13752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=13752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"New](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/12\/16.png\" "\\"New")
<\/p>\n<\/p>\n