Shipping Decision

Raw item weight is in B2 as text ending in lowercase kg; ordinary spaces are allowed. Destination is Local or Remote in C2. In D2, convert the cleaned weight to a number or show Check if invalid. In E2, show Review for invalid or negative weights. Otherwise show Standard only when weight is at most 10 and destination is Local; show Special for every other valid shipment.

Enter formulas in the highlighted output cells: D2, E2. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.