The Excel function: SWITCH
Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
More information: support.microsoft.com/en-us/office/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e
Other functions
Returns TRUE if all of its arguments are TRUE
Returns the logical value FALSE
Specifies a logical test to perform
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
Reverses the logic of its argument
Returns TRUE if any argument is TRUE
Returns the logical value TRUE
Returns a logical exclusive OR of all arguments