Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
Description: Switch functions basically replace on given expression against your value which is being prescribed in the function. Like in the above example we have country abbreviations like US, UK, CA, etc and we want to replace such expressions with a full country name like United states for the US, the United Kingdom for Uk, and Canada for CA respectively. We will use the SWITCH and Helper function i.e. RIGHT function to do that.
Switch Function Expression;
SWITCH (expression, value1, result1, [default or value2, result2],…[default or value3, result3])
Follow the video with below table content to browse through the timeline.
01:50 Switch Function in Excel
08:30 Switch Function Limitation