A report should tell the packing team which shipping totals need attention. In D2 calculate =B2*C2, where B2 is the parcel count and C2 is the unit cost. In E2 use =IFERROR(D2,"Check inputs").
Put a bad rate through the whole row
Use count 6 and type pending in the cost cell. D2 should show a formula error and E2 should display Check inputs. When you see the message, read the raw error in D2 before deciding whether the rate is missing or a reference broke.

Illustrated error handling. Keep D2 available for diagnosis.
Confirm both a positive total and a real zero
Replace pending with 4 and expect 24. Then set the count to 0 and expect 0. This display rule catches errors. If a blank input is invalid but the calculation interprets it as zero, add an explicit completeness check.

Illustrated control cases. A valid zero stays numeric.



