IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points
Turn a product code into a category
The situation
Every Harbor Supply SKU starts with a two-letter category prefix, but the sales report shows raw codes and nobody outside the warehouse knows what EL means. Merchandising wants the category spelled out beside each line.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Code | Category | |||
| 2 | HW-4820 | ||||
| 3 | PL-1175 | ||||
| 4 | EL-9043 | ||||
| 5 | HW-2266 | ||||
| 6 | EL-7710 | ||||
| 7 |
Functions in this exercise
Who this is for
Recommended next
Related exercises
- IntermediateLogical Functions
Apply commission tiers with IFS
Return the right rate from several tiers without nesting.
IFS
10 min25 points - IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points - BeginnerText Functions
Split a full name with LEFT and FIND
Pull the first name out of a single full-name column.
LEFT · FIND
7 min15 points