Google Sheets reference

SWITCH in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Conditional Logicintermediate

=SWITCH(A2,"N","North","S","South","E","East","W","West","Unknown")

Also in Excel

See the full SWITCH reference for Excel — including all worked examples, common errors, and FAQ.