By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-switch-function/

Learn how to use the SWITCH function Microsoft Excel to compare a value with a list of options and return different results. You'll learn how to use SWITCH to compare numeric and text values, and how to adapt the SWITCH function to allow you to write logical tests.

Chapters
00:00 Topic list
00:29 A Basic SWITCH Function
04:26 Comparing Text
06:14 Logical Tests in the SWITCH Function

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!