Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conditional Formatting Icon Sets Examples in Excel
  • How To Create Frequency Distribution in Excel
  • Error Bars in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • How To Remove Duplicates In Excel Column Or Row?

References

  • How to get last row in numeric data in Excel
  • Extract all partial matches in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel MMULT Function
  • How to calculate two-way lookup VLOOKUP in Excel Table

Data Validations

  • Excel Data validation must not contain
  • Excel Data validation allow weekday only
  • Excel Data validation date in specific year
  • Data validation must not exist in list
  • Excel Data validation only dates between

SWITCH function: Description, Usage, Syntax, Examples and Explanation

by

What is SWITCH function in Excel?

SWITCH function is one of the Logical functions in Microsoft Excel that evaluates one value (called the 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.

Syntax of SWITCH function

In its simplest form, the SWITCH function says:

  • =SWITCH(Value to switch, Value to match1…[2-126], Value to return if there’s a match1…[2-126], Value to return if there’s no match)

Where you can evaluate up to 126 matching values and results.

See the following formula:

  1. Value to switch? In this case, WEEKDAY(A2) equals 2.
  2. What value do you want to match? In this case, it’s 1, 2 and 3.
  3. If there’s a match, what do you want to return as a result? In this case, it would be Sunday for 1, Monday for 2 and Tuesday for 3.
  4. Default value to return if there’s no match found. In this case, it’s the text “No match”.

    Note: If there are no matching values, and no default argument is supplied, the SWITCH function returns the #N/A! error.

Examples of SWITCH function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Example

Value Formula Result
2 =SWITCH(WEEKDAY(A2),1,”Sunday”,2,”Monday”,3,”Tuesday”,”No match”) Because A2=2, and Monday is the result argument corresponding to the value 2, SWITCH returns Monday
99 =SWITCH(A3,1,”Sunday”,2,”Monday”,3,”Tuesday”) Because there’s no match and no else argument, SWITCH returns #N/A!
99 =SWITCH(A4,1,”Sunday”,2,”Monday”,3,”Tuesday”,”No match”) No match
2 =SWITCH(A5,1,”Sunday”,7,”Saturday”,”weekday”) weekday
3 =SWITCH(A6,1,”Sunday”,2,”Monday”,3,”Tuesday”,”No match”) Tuesday

For more SWITCH function example visit:

  • SWITCH function example in Excel

Post navigation

Previous Post:

How to generate random date between two dates in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel
  • Check multiple cells are equal in Excel

Date Time

  • How to calculate workdays per month in Excel
  • Display the current date in Excel
  • Extract date from a date and time in Excel
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Add days exclude certain days of week in Excel

Grouping

  • Map inputs to arbitrary values in Excel
  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel
  • How to randomly assign data to groups in Excel
  • Categorize text with keywords in Excel

General

  • Subtotal invoices by age in Excel
  • Count cells that do not contain errors in Excel
  • How to set or clear a print area in Excel Worksheet
  • Excel Operators
  • Freeze and Unfreeze Panes in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning