Description of the SWITCH function in Calc is confusing, and also omits any mention of the optional default ("else") value, cf. https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e
I just tested that specifying a default value actually works as expected, it is just not documented/mentioned in the function description as it should be.
Current wording: "Checks 1 or more values and returns a result corresponding to the first value equal to the given expression."
Better wording: "Tests an expression against a list of values and returns the result corresponding to the first value equal to the expression. Optionally, a default value may be set, to be returned if none of the values match the expression."
A new field should be added for the default value in the Functions wizard.
Description for "expression" field should be slightly changed as well.
Currently: "Value that will be compared against value1-valueN."
Better: "Value that will be compared against value1...value30." (to remove possible ambiguity of the dash/minus sign)De
The SWITCH function was added in bug #97831 - added as "see also".
Help page request for SWITCH, among others, at bug #99517.
Seems like a perfectly valid suggestion.