Switch Function in #excel #ExcelSwitchFunction #shorts #short

In Excel, the SWITCH function is used to evaluate an expression against a list of values and return the corresponding result for the first matching value. It is similar to the traditional SWITCH statement in programming languages.

Syntax :
=SWITCH(expression, value1, result1, [value2, result2], ..., [default])
=SWITCH(C2, 1, "Jan", 2, "Feb", 3, "Mar", 4, "Apr", 5, "May", 6, "Jun", 7, "Jul", 8, "Aug", 9, "Sept", 10, "Oct", 11, "Nov", 12, "Dec")

#ExcelSwitchFunction
#ExcelFunctions
#SpreadsheetTips
#DataAnalysis
#ExcelFormulas
#ExcelTutorial
#DataManipulation
#ExcelTipsAndTricks
#Spreadsheets101
#ExcelHelp