Scribd
Upload
13 views1 page

Understanding the SWITCH Function in Excel

The SWITCH function evaluates an expression against a list of values and returns the corresponding result for the first match, with an optional default value if no match is found. It can handle up to 126 matching values and results. An example illustrates its use with the WEEKDAY function, returning specific days of the week based on the evaluated value.

Uploaded by

pranavshankarkp9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views1 page

Understanding the SWITCH Function in Excel

The SWITCH function evaluates an expression against a list of values and returns the corresponding result for the first match, with an optional default value if no match is found. It can handle up to 126 matching values and results. An example illustrates its use with the WEEKDAY function, returning specific days of the week based on the evaluated value.

Uploaded by

pranavshankarkp9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SWITCH function

The SWITCH function 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.

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".

You might also like