{"id":440,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/switch\/"},"modified":"2021-02-13T11:36:35","modified_gmt":"2021-02-13T11:36:35","slug":"switch","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/switch\/","title":{"rendered":"SWITCH"},"content":{"rendered":"

Today, we’ll delve into the SWITCH function in Excel and Google Sheets. This function compares an expression against a set of values and returns a result for the first match found. It is particularly useful for streamlining complex nested IF statements, as it allows you to handle multiple conditions and outcomes within a single formula.<\/p>\n

Basic Syntax<\/h2>\n

The syntax for the SWITCH function is consistent across both Excel and Google Sheets:<\/p>\n

=SWITCH(expression, value1, result1, [default_value or value2, result2], ... [default_value, default_result])<\/code><\/pre>\n
    \n
  • expression:<\/strong> The value or expression you want to evaluate.<\/li>\n
  • value1:<\/strong> The first value to which the expression is compared.<\/li>\n
  • result1:<\/strong> The outcome returned if there is a match between the expression and value1.<\/li>\n
  • value2, result2:<\/strong> Additional pairs of values and their corresponding outcomes to consider.<\/li>\n
  • default_value:<\/strong> An optional value used if no other specified values match the expression.<\/li>\n
  • default_result:<\/strong> The outcome returned if there are no matches to any given value (associated with the default_value).<\/li>\n<\/ul>\n
    Examples<\/h2>\n
    Let\u2019s explore some practical examples to better understand the SWITCH function:<\/p>\n\n\n\n\n
    Example<\/th>\nDescription<\/th>\nExcel Formula<\/th>\nResult<\/th>\n<\/tr>\n
    Example 1<\/td>\nCheck the day of the week.<\/td>\n=SWITCH(A2, 1, \"Sunday\", 2, \"Monday\", 3, \"Tuesday\", 4, \"Wednesday\", 5, \"Thursday\", 6, \"Friday\", 7, \"Saturday\", \"Unknown\")<\/code><\/td>\nIf A2 = 1, returns “Sunday”; if A2 = 2, returns “Monday”, and so on up to 7. Returns “Unknown” if A2 is outside 1-7.<\/td>\n<\/tr>\n
    Example 2<\/td>\nAssign grades based on scores.<\/td>\n=SWITCH(B2, 1, \"Fail\", 2, \"Pass\", 3, \"Merit\", 4, \"Distinction\", \"Invalid Score\")<\/code><\/td>\nIf B2 = 1, returns “Fail”; if B2 = 2, returns “Pass”; and so forth. Returns “Invalid Score” if B2 does not match 1, 2, 3, or 4.<\/td>\n<\/tr>\n<\/table>\n
    Conclusion<\/h2>\n
    The SWITCH function is an invaluable tool for managing conditional logic in Excel and Google Sheets. It offers a more succinct and clear approach to handling multiple conditions in your formulas. By mastering the syntax and examples provided, you can leverage the SWITCH function to enhance the efficiency and clarity of your spreadsheet tasks.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Evaluates an expression against a list of values and returns the result corresponding to the first matching value If there is no match, an optional default value may be returned<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[201],"tags":[],"class_list":["post-440","post","type-post","status-publish","format-standard","hentry","category-logical"],"acf":[],"yoast_head":"\nExcel SWITCH Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel SWITCH function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/switch\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel SWITCH Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel SWITCH function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/switch\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:36:35+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel SWITCH Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/switch\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/switch\/\",\"name\":\"Excel SWITCH Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:36:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel SWITCH function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/switch\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/switch\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/switch\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Logical\",\"item\":\"https:\/\/functiontranslator.com\/en\/logical\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SWITCH\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel SWITCH Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel SWITCH function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/switch\/","og_locale":"en_US","og_type":"article","og_title":"Excel SWITCH Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel SWITCH function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/switch\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:36:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel SWITCH Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/switch\/","url":"https:\/\/functiontranslator.com\/en\/switch\/","name":"Excel SWITCH Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:36:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel SWITCH function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/switch\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/switch\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/switch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Logical","item":"https:\/\/functiontranslator.com\/en\/logical\/"},{"@type":"ListItem","position":3,"name":"SWITCH"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=440"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/440\/revisions"}],"predecessor-version":[{"id":3331,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/440\/revisions\/3331"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}