Welcome! Lets start your excel journey..

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

Admin
Duration: 10:16
Submitted: 2 weeks ago
Views: 29

Comments (0)

Link to this video:

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