Welcome! Register Now to Unlock Exclusive Excel Tutorials
Get Started- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
How to use SWITCH Function in Excel
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. 00:00 Introduction 01:50 Switch Function in Excel 08:30 Switch Function Limitation 09:38 Conclusion