Use @CASE to select a value depending on a series of value tests.

@CASE (PRODUCT_CODE, 'CAR', 'A car', 'TRUCK', 'A truck')

This example returns the following:

• A car if PRODUCT_CODE is CAR

• A truck if PRODUCT_CODE is TRUCK

• A FIELD_MISSING indication if PRODUCT_CODE fits neither of the other conditions