Practice / Logic

Difficulty 3 of 5 · about 4 min

Map country codes to shipping zones

Column B holds the destination country code for each shipment, in B2:B6. In D2, write ONE formula that fills D2:D6 with the shipping zone for each code: IN is "Domestic"; AE and SG are "Zone 1"; US, GB and DE are "Zone 2"; any other code is "Zone 3". Type the zone names exactly as shown and leave D3:D6 empty. Use ARRAYFORMULA with IFS.

Loading grid…