Best on desktop

The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.

Optimize — 6-Deep Nested IF → SWITCH (or IFS)

mediumIF / Nested IF

A subscription-ops analyst's status-code translator uses a 6-level nested IF that's a nightmare to read in code review:

=IF(A2="A", "Active",
  IF(A2="B", "Pending",
    IF(A2="C", "Suspended",
      IF(A2="D", "Cancelled",
        IF(A2="E", "Expired",
          IF(A2="F", "Trial", "Unknown"))))))

This is a textbook case for SWITCH — when you have a finite set of literal values to map to other values, SWITCH is shorter, flatter, and harder to mess up. The mapping:

Code	Description
A	Active
B	Pending
C	Suspended
D	Cancelled
E	Expired
F	Trial
(anything else)	Unknown

Your task:

In column B (Description), write a SWITCH (or IFS) formula that returns the right description for each code in column A.
The formula must drag-fill from B2 → B13.

Graded cells: B3 (C → Suspended), B5 (F → Trial), B6 (D → Cancelled).

Open this problem on a desktop to attempt it.