Conditional Logic

Excel formula for Map values with SWITCH

Translate codes or categories into labels cleanly with SWITCH.

Copy this formula

=SWITCH(A2, "N", "North", "S", "South", "Other")

How the formula works

SWITCH compares one value against a list of cases and returns the matching result; the final lone argument is the default. It's clearer than a stack of nested IFs when mapping fixed codes.

Examples

=SWITCH(A2, 1, "Low", 2, "Mid", 3, "High", "?")→Mid

Maps 2 to "Mid".

Other ways to do this

Nested IF (older Excel)

=IF(A2="N","North",IF(A2="S","South","Other"))

Use when SWITCH isn't available.

FAQ

SWITCH vs IFS — which to use?

Use SWITCH for exact matches of one value; use IFS for range conditions like >=90.

Related formulas

Assign grades or tiers with nested logic IF with AND / OR conditions

Functions used

SWITCH IF IFS

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free