How to use Switch function in Excel
The “SWITCH” function in Excel is a new function introduced in Excel 365 and can be used to evaluate a list of conditions and return a corresponding value for the first matching condition. It is similar to the “IF” function, but it provides a simpler syntax for evaluating multiple conditions.